I have a database with the following content:
Field 1 Field 2 Field 3 Field 4
Object "Orders" CustID OrderID Item Price
Object "Status" OrderID Date Time Status
I have an orders table that contains info from the orders object. The status object is updated as I receive info from the vendor. Every order goes through several status changes until complete.
How do I connect the Orders Object to the Status Object without overwriting the previous updates? I import the status information from an Excel CVS file.
How do I add the status element to the orders table so that I can see all of the past status information sorted by date and time?