sub form select from one table to save to another table
Hello all,
I have a database with 2 tables. The first table shows details of an order including customer details. The second table is the stock details table. This holds info about stock such as the name and code etc.
I want to have a form for new orders that the user will be able view and select stock from the stock table but save it in the order table. Would a sub form do this?
Basically I want the user to b able to use th form to record the customer details which woul save into the order table and the items they buy. It would need to be able to view and select stock from the stock tble and save it to the order table.
Is this possible?
Would I use a sub form or ........?
Sorry if I have missed out any bits.
Thank-you,
Rue
Hello all,
I have a database with 2 tables. The first table shows details of an order including customer details. The second table is the stock details table. This holds info about stock such as the name and code etc.
I want to have a form for new orders that the user will be able view and select stock from the stock table but save it in the order table. Would a sub form do this?
Basically I want the user to b able to use th form to record the customer details which woul save into the order table and the items they buy. It would need to be able to view and select stock from the stock tble and save it to the order table.
Is this possible?
Would I use a sub form or ........?
Sorry if I have missed out any bits.
Thank-you,
Rue
Last edited:
