I have finished about half the db for Inventory and Purchase Orders. With my brain, that's impressive!
I am using the same Products table to reference on for Inventory.
I don't believe my Relationships are correct since my Table does not display the correct data.
The Form I am using uses both the Products table and the OrderDetails table and together they can show me everything.
Trying to use 2 different form to both add and subtract from Inventory.
Subtract works fine and shows what the customer has bought and all.
Purchasing, i.e. Buying Products has proved a challenge for me.
I thought that if the relationships were correct, when you added 2 or more tables, they linked by themselves?
If you change the relationship in a query, does it then change it in the Relationships?