nubidns
|
Posted: 05/28/2004, 12:21 PM |
|
I have to tables in a one to one relationship:
Contact Table (c_id is PK)
Member Table (c_id is PK)
All members are contacts but not all contacts are members.
Creating contact records alone is simple.
Creating member records is my question. When a visitor to the registration
form wants to become a member, they need a form with both the contact fields
and the member fields. When they are finished I need both tables have a
record created similar to below:
Contact Table
c_id Name
1 Jim
Member Table
c_id status
1 Approved
In order to maintain relationship integrity of the member record I have to
know the c_id of the contact that is not yet created. How can I do this with
one form?
Using CCS and MS SQL
JimS
|
|
|
|