Hello there,
Apologies if this has been posted before but I am unable to find a solution.
Say I am trying to create a database to record sales and I have the following tables (simplified for easier posting here):
Orders tbl:
OrderID (Primary Key)
Date
Stock tbl:
Product Name (Primary Key)...