Last post Jun 08, 2012 04:04 AM by hamsaeed
Jun 08, 2012 01:38 AM|hamsaeed|LINK
my tabels are:
I store shopping cart in tblOrder and tblOrderDetail ,and when user click
Payment ,i delete records of tblOrder and tblOrderDetail, and then i want
store them in tblInvoice ,
can you help me for find best relationship between them,Please?
Thanks for your help,
Jun 08, 2012 02:45 AM|sravanisrav|LINK
Hace a foriegn key of tblOrder in tbleOrderDetails as fkIdOrder.
When you delete a record of tblOrder using its primary Key also delete the tblOrderDetails record by passing the foriegn key.
and have forign keys of both tables in tblInvoice to insert that record.
For more info on ADO.Net follow the link:
Jun 08, 2012 04:04 AM|hamsaeed|LINK
Hi and thanks,
I want record of tblOrder and tbleOrderDetails delete and move them to tblInvoice ,
Now , Relationship for tblInvoice and etc and field of tblInvoice ?
Thanks fpr your Help?