create dropdown list in a form with one to many relation

lico

Registered User.
Local time
Tomorrow, 01:28
Joined
Jan 11, 2008
Messages
20
Hi all,
i'm sure it's simple question but i'm new to access.
i have two tables, one contain Suppliers information and the other one includes information on orders i made from this suppliers. i would like to create a form that feeds data to the orders table. i'm trying to create the form so i can choose the name of the supplier from a rolldown list then add as many items as i want to this specific supplier. i managed to create a form in wich i have to choose the supplier name for every item.

the tables are realted in this way:
Suppliers table includes SupplierID Filed and the Orders table contain the same field
 
create a main form for your supplier. Then use the combo box wizard to create a combo box that list all the supplies and loads the selected supplier. Next create a sub form for the orders and link the parent/child keys which in your case is the Supplier ID.
 
Hi Dennisk,
thank you for your replay.
 

Users who are viewing this thread

Back
Top Bottom