Help with database design

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 397,603 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,590 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Thread Tools Display Modes

Views: 750 | Replies: 2

Previous Post in Thread

Next Post in Thread

•

Join Date: Nov 2007

Posts: 3

Reputation: fairchild is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

fairchild

Offline

Newbie Poster

Help with database design

Nov 1st, 2007

Hi there,

My database contains two tables namely Products and Stocks. Product table consists of ProductName(VARCHAR[100]), PackingStyles(VARCHAR[2000]) and Grades(VARCHAR[2000]). Primary Key is the combination of these three fields. The values of PackingStyles and Grades are entered using a listbox and so they are stored as comma separated values. The Stocks and Products tables are related. When a user selects a ProductName in the Stocks table I want to form a grid based on PackingStyles and Grades. The user enters the cell values into the grid and these values must be stored in the Stocks table. Later the user may change the order of PackingStyles and Grades in the listbox or he may change the values of PackingStyles or Grades and insert a new value in the Stock based on the modified data from the Products table. In the end the user may calculate total stocks by adding these values (which is in the form of a grid formed by Packingstyles as Columns and Grades as rows with inputted values as cell values). Please help in this regard.

Thanks in advance

Fairchild