By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Inventory Management

P: 77
Friends,

I am making an inventory management system for my office.

I have 3 tables namely;

Recd_Items
Item_code - FK
Item_Recd - Numeric

Issue_Items
Item_Code - FK
Issue_Qty- Numeric


Item_Master
Item_Code - PK
Item_Desc - Text
Item_Rol - Numeric

The problem is when an user is requiring more than one item. For eg.
If I am filling up a requisition form for the following items:

One Pen
One stapler
One Glu stick
etc.

the user wants to make an entry for these 3 items together, rather than making entry 3 times for the same user. I hpe I am able to make u understand.

looking forward to hear from you all.
May 29 '08 #1
Share this Question
Share on Google+
2 Replies


pod
100+
P: 298
pod
Friends,

I am making an inventory management system for my office.

I have 3 tables namely;

Recd_Items
Item_code - FK
Item_Recd - Numeric

Issue_Items
Item_Code - FK
Issue_Qty- Numeric


Item_Master
Item_Code - PK
Item_Desc - Text
Item_Rol - Numeric

The problem is when an user is requiring more than one item. For eg.
If I am filling up a requisition form for the following items:

One Pen
One stapler
One Glu stick
etc.

the user wants to make an entry for these 3 items together, rather than making entry 3 times for the same user. I hpe I am able to make u understand.

looking forward to hear from you all.
I am not certain what the problem is with having three entries with the same user.

Good database design sometime looks simplistic and repetive i.e. 3 entries for the same user but with different items for each entry
May 30 '08 #2

P: 77
Exactly thatz wat i want......how do i do it....???

sajit

I am not certain what the problem is with having three entries with the same user.

Good database design sometime looks simplistic and repetive i.e. 3 entries for the same user but with different items for each entry
Jun 2 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.