Design help plz

Reply

Join Date: Sep 2007
Posts: 18
Reputation: tomjohnson is an unknown quantity at this point 
Solved Threads: 0
tomjohnson tomjohnson is offline Offline
Newbie Poster

Design help plz

 
0
  #1
Sep 5th, 2007
Hi all. My first post here. I would like to know if someone can give me some advice on how to model inventory that comes in and goes out and then comes back in again. The inventory is basically loaned out and then returned and re-loaned out again.

I can't model this correctly for some reason. What I would like is to also keep a history of the people that have been loaned this equipment.

Any help would be greatly appreciated.

Tom
Reply With Quote Quick reply to this message  
Join Date: May 2007
Posts: 38
Reputation: matale is an unknown quantity at this point 
Solved Threads: 1
matale matale is offline Offline
Light Poster

Re: Design help plz

 
0
  #2
Sep 5th, 2007
An Inventory table with the item_id,item_description

A loans table which will contain the item_id of items that have been loaned out, the date out, the return date, and any other info u need, you could also put the customer details in here or even beter in a different customers table.
My current Project www.footystat.com
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC