Hello everyone.
First, I'm sorry the title doesn't give any info about the help I need, but I don't know what to call it and english is not my primary language.
I want to develop a simple inventory/stock management database.
I've started by making a table called "Items", where I list all items I can order. It has the fields "Code", "Name1" and "Name2".
Then I created a table named "Stock", which will contain the same fields as the "Items" table, plus "Quantity" and "Expiry date". It's the location where the items will be stored, so when I add or subtract an item quantity, I'll know how much I have in stock. Plus, I want to know the expiry dates, so if the same items have different expiry dates, they will be saved separately.
My problem is that when I try to add a record in "Stock" table, I can get a drop down menu choosing the item's code. But I wanted to automatically appear the "Name1" and "Name2" fields as well, which are already defined in the "Items" table, although still giving the chance for the user to type a new "Name2" (for different brands of the same item).
And that's where I'm stuck. Can you help me, please?
Best regards,
Angelo