hey guys i been working on this issue for a long time and still cant figure it out...please help me out if you can..
i have a inventory table that stores items, a customer sales table that stores customer information.
i have a form that i named the "sales invoice" it stores and gets the data from the customer sales table...
within that form i have a subform that gets the data from the inventory table... or at least thats what i want it to do...
here is a printscreen of what my form somewhat looks like....(see attachment)
my issue is that i cant get the subform to work properly... i've tried many different ways but i am some what new to access...
in the subform where is reads LOT# thats basically my SKU or unit product code... all this data along with everything in the subform is stored in the inventory table..
the information in the inventory table is already pre entered so what i want is to click on that LOT # and what ever # i select it will autofill the rest of the subform record..
just like a regular sales invoice... i want to select the item and have it fill up the description, price and so on....
i have a inventory table that stores items, a customer sales table that stores customer information.
i have a form that i named the "sales invoice" it stores and gets the data from the customer sales table...
within that form i have a subform that gets the data from the inventory table... or at least thats what i want it to do...
here is a printscreen of what my form somewhat looks like....(see attachment)
my issue is that i cant get the subform to work properly... i've tried many different ways but i am some what new to access...
in the subform where is reads LOT# thats basically my SKU or unit product code... all this data along with everything in the subform is stored in the inventory table..
the information in the inventory table is already pre entered so what i want is to click on that LOT # and what ever # i select it will autofill the rest of the subform record..
just like a regular sales invoice... i want to select the item and have it fill up the description, price and so on....
