I have tried my best to find the answer in another thread, but haven't found anything that worked.
I am making a simple inventory database with Purchases, Sales Orders, and Transactions tables.
Purchases has Item ID (PK), Item Name, and Cost. Sales Orders has Sales ID (PK), Sales Date, and...