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 391,764 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 3,194 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: 740 | Replies: 2

•

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

•

Join Date: Aug 2007

Location: KSA

Posts: 147

Reputation: kb.net is an unknown quantity at this point

Rep Power: 2

Solved Threads: 26

kb.net

Offline

Junior Poster

Re: Help with database design

Nov 1st, 2007

Hi,

What programming language are u using ??

It is never about the number of languages you know, you either have the logic of programming or you don't ...

Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.