Design help plz

Expand Post »

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

Similar Threads

can someone plz help me with this? in Visual Basic 4 / 5 / 6
I NEED SUPPORT **"IMPORTANT"** PLZ HELP in Windows NT / 2000 / XP
Image Editing Help Required. ( Graphic Desingning Guru's Plz share your knowledge ) in Graphics and Multimedia

tomjohnson

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Sep 2007

Permalink

Sep 5th, 2007

Re: Design help plz

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.

matale

Reputation Points: 22

Solved Threads: 1

Light Poster

Offline

38 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: SQL Query Analyzer Problem

Next Thread in Database Design Forum Timeline: web based datbase question about email

DaniWeb Message

Cancel Changes

User Name
Password