AnsweredAssumed Answered

Inventory DB issues...

Question asked by Chazz on Jan 8, 2010
Latest reply on Jan 11, 2010 by philmodjunk

Title

Inventory DB issues...

Post

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..

Outcomes