Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wlee
Starting Member
1 Post |
 Posted - 2010-03-18 : 22:50:57
|
| Hi everyone.. I hv an urgent question would like to ask your guys for help..My question is: I hv sales order table, Delivery Order table and Invoice table.Normal procedure is after Sales Order, Delivery Order will be created, then follow by Invoice.But Sales Order can have an invoice/multiple invoices directly without create the delivery order.Sales Order may also hv more than one Delivery Order.May I know how to link this three tables together from the Sales Order table?Many thanks!! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-03-18 : 23:17:42
|
both DO & INV has foreign key to SO.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Pls HELP!! URGENT.. MANY THANKS!!