views:

37

answers:

0

Hi I have a form (form1) which should gather information from user and save them into DB. In form1, I have 4 different groups:

Group1: Operational Costs(Material, Salary, Maintenance)
Group2: Selling Costs(Advertisement, Transport, Operational Costs)
Group3: Financial Costs (Benefit, Penalty)

Every option like Material, Salary, Maintenance, Advertisement,...Penalty should have a checkbox control in order to get what the user's option.

As you see above, Group2 contains 3 branches and the last one of them is Group1.

Now, What is the best design for a table for saving data into DB form this form?

I use SQL Server 2005 and Vb6.0. THANK YOU