
January 24th, 2004, 06:42 AM
|
|
Junior Member
|
|
Join Date: Jan 2004
Location: UAE
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Access Form: selecting specific record based on some key value
problem is that : As i'm new to access and posting this question.
i have a product_info table with information about product and an order_detail table; product_id in order detail is serving as FK which is PK in product_info table.
Now while form designing (Using Access) in order_detail i want to display a list in seprate window just like LOVs in Oracle; and after selecting the record , 'product_name' and 'price' values against the product_id should be pasted and selected in the displayed fields of order_detail form.
Please help.
Tanveer.
|