Hi,

Could anyone please assist me in the creation of an inventory database. I have made about 6-7 tables, one with the user and one for each item you can sign out and with the relationship one user to many items, and User_ID as FK in every table. So I would like to creat some kind of an overview where you can put in the name or ID of an person and see how many items this person signed for. So e.g John has signed for two laptops, one radio and two mobile phones. Please anyone with some nice tips how to create the question and how to make it look nice in a form or so.

Thanks in advance!

Regards,
Kim

I think it would make more sense to have one table for the people part and their details and one other table for the inventory part with pertinent details. One field of the second table could be EquipmentType to put if it is a computer or camera or whatever.
This would be easier to drill down the information with queries.