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 - 2000-11-30 : 16:12:31
|
Josh writes "I'm working with an Access database in ASP. It's for a threaded messageboard system. One of the fields is called 'Parent' and should represent the Record ID # ('ID' field) of the message's parent message. In cases where the message is a new topic, I want this value to be this record's OWN 'ID' value. The 'ID' field is an AutoNumber Long Integer.
So what is the best way to create a new record (preferably with an INSERT INTO statement rather than using an ADO recordset object) such that the 'Parent' field value mirrors the value of this same, new record's 'ID' field?" |
|
|
|
|
|
How to make one field mirror another's AutoNumber value.