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 |
|
yvette
Yak Posting Veteran
74 Posts |
 Posted - 2010-09-23 : 00:21:18
|
| Hi,i have three table(customer, car and job).Customer -- customer ID(PK) (auto generate) example C0001Car -- Customer ID(PK) (auto get value from customer table) -- Car Plate NoJob -- Car plate no(PK)scenario:when register button click, the customer table will generate customer ID and will pass (customer ID) to Car table directly. And Car table will pass the Car plate no to job table.My problem is how to pass car plate no from car table to job table???thanks... |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-09-23 : 01:44:22
|
| What you mean by "how to pass"?Shouldn't it be a simple matter of an insert statement where you insert in Car & job tables when user clicks register button?PBUH |
 |
|
|
yvette
Yak Posting Veteran
74 Posts |
Posted - 2010-09-23 : 01:54:43
|
quote:
Originally posted by Sachin.Nand
What you mean by "how to pass"?Shouldn't it be a simple matter of an insert statement where you insert in Car & job tables when user clicks register button?PBUH
ok.Thanks....i get it.... |
|
|
|
|
|
|
pass value to other table