Hi Richard,
I think you tutorials are great thanks. I have a question as I am going through the tutorials I am trying to create an asset database and understand that I would have to create a table for the assets eg make, model, serial number etc and a table for the customer/user eg firstname, lastname, emailaddress, owner of asset. but where do I put eg return of asset, date returned, type of asset, who returned it and reissue asset, date reissued, type of asset to new customer.
Thanks for your help.
Serina

---

Reply from Richard Rost:

You would need a third table to track transactions. Table 1 would be customers. Table 2 would be assets. You would need a JUNCTION TABLE to track the history of each of your assets. This creates a MANY-TO-MANY relationship.

ID, CustomerID, AssetID, TransactionDate, Notes, etc.

I cover this in detail in my Relationship Seminar.