Click here to Skip to main content
15,902,893 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi

My project is invoice Management i have tables like customer details , Items & Calculation i am confused with the Item Table since this is my first project not able to design properly
item table i have fields like Item No,Description,Qty,donumber,dodate and cusid.

Item No,Description,Qty - taking value from dynamic textbox and save it in datatable -to insert database.

how do i add the other three values? Donumber i have to make us primarykey and in my next table it will be foreign key. pls help

Thanks
Posted

1 solution

Hi,

You Can learn from Here How to Design Database....
http://www.databaseanswers.com/data_models/[^]
 
Share this answer
 
Comments
Lancy.net 15-Nov-11 2:29am    
Thanks Tushar for your repy .. the link is not opening .. do you know any other links like this?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900