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
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