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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-24 : 08:51:07
|
Malika writes "hi,
on my insert page, how can i update my userID on the current table where personalID is the primary key and userID the foreign key?
e.g. my Db
table 1
userID - autonum
username - text
passowrd - text
table 2
personalID - autonum
userID - text
title - text
city - text
the user logged on with the username and password of table 1, now he is inserting info which will go in table 2, but based from previous page how can i insert the userID in table 2 since i want to display the userID and title in next page?
thanks a trillion!!!" |
|
|
|
|
|
Updating foreign key based on primary kep