Inventory DB issues...
Hello, I'm new to database's and I'm currently trying to build a database that can manage contacts and equipment. This equipment is loaned to these contacts. I would like a form that shows the contact info and what equipment is currently loaned to them. I would like it to subtract from the equipment inventory when this item is assigned so I know what I have on hand as well as when they return the item the inventory returns to original number. (Think of it like renting video's to a customer I guess)
So... I assume to accomplish this I need to make 2 tables one for contacts and one for equipment these items will be relational. How can I connect these two tables to obtain the above goal? Any examples/input that can get me started in the right direction would be appreciated! Thanks..