Morning Gents/Ladies, I'm having an issue with the relation between tables. Any suggestion would be appreciated. Basically I have an Inventory which holds equipment and that I sign out to individuals. I would like to be able to keep track of all my inventory from sitting in my shop or some Bloggins desk.
My Design
t_Person -->PersonID PriKey
t_Laptop -->LaptopID PriKey
-->PersonID Foreign
t_Phone -->PhoneID PriKey
-->PersonID Foreign
t_Printer -->PrinterID PriKey
-->PersonID Foreign
A Person can have as many items he wants, an Item can only belong to 1 person.
When PersonID=0, it means the item is sitting on my shelf. The issue I am having is how to query all the information. IE, I want to see everything PersonID=3 has on loan.
PersonId=3 has 2 Laptop, 1 Phones, 0 Printers
Outcome:
Bloggins Panasonic Toughbook 1, Panasonic Toughbook 2, Blackberry, Nil
Hopefully I've given enough detail for some input. Thanks in advance.