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