Hello I want to make an access file for purchase order. feature need are as below.
1.There will be two table
A. Item which should have below fields
1. Item Code
2. Item Description
B. Purchase Order which should have below fields
1. Item Code
2. Item Description
3. Date
4. Purchase order number
Now I want that someone will search from table item & field description. Say search result give 05 rows. Every row should contain a button. After clicking the button a purchase form will open related to search result and table purchase order.
Now please help me.