I am working on a database that needs to keep track of what shipments of books clients have received and when. Here are the tables I have (with some made-up values):
|Code (unique)||Client Name|
|Shipment Code UUID||Client Code||Issue||Date|
Obviously, The Shipment table is the related table between the two that keeps track of every shipment. My question is this: from the Client table layout, how can I input data for new shipments AND have the data for previous shipments appear as I do so (only for shipments that apply to that particular client, of course)?
I want to be able to see something like this in the Clients layout:
|Book 3||Not recvd|
|Book 4||Not recvd|
|Book 5||Not recvd|
Then, I want input dropbox and date box that can enter new shipments.