I am creating a database for sales purposes. It has an iventory table with a form that controls it and a Customer table with a Sales Form that controls it.
Now I created a subform based on the Inventory table that will be on the Sales form. It sort of works but not the way i want it to work. Right now it just allows me to enter data into the subform and it is reflected in the inventory table. But what i want to do is to be able to select an item from the subform based on the key which is a SKU#. I just want to be able to click on the subform select any of the items from my inventory and have it reflected on that sales invoice form and also being able to have multiple line items.
Is is best to create the subform off a table or create a separate form for it and then use it as a subform?
Thanks!
Now I created a subform based on the Inventory table that will be on the Sales form. It sort of works but not the way i want it to work. Right now it just allows me to enter data into the subform and it is reflected in the inventory table. But what i want to do is to be able to select an item from the subform based on the key which is a SKU#. I just want to be able to click on the subform select any of the items from my inventory and have it reflected on that sales invoice form and also being able to have multiple line items.
Is is best to create the subform off a table or create a separate form for it and then use it as a subform?
Thanks!
