I am doing a registration module in which I need to make inserts into three tables. The memberid field is a primary key in Member table, & a refrential key in the other 2 tables. But since at the time of registration i do not have access to the value of memberid, since the registration process is incomplete. Can I create a sequence on the memberid field which is an autonumber & get the next value of the memberid proir to insertions in SQLServer2000.
Awaiting an active particpation from all you highly knowledgeble netizens
Thanks in advance.