child records [message #458150] |
Thu, 27 May 2010 10:40 |
sandy_tp
Messages: 9 Registered: May 2010 Location: india
|
Junior Member |
|
|
Hi,
I have a table with two child tables. For each record in the parent
table, I want one and only one record in one of the child tables --
not one in each, not none. How to I define that?
Here's the backstory. Feel free to criticize this implementation, but
please answer the question above, because this isn't the only time
I've encountered it:
I have a database that holds data pertaining to user surveys. It was
originally designed with one authentication method for starting a
survey. Since then, requirements have changed, and now there are two
different ways someone could sign on to start a survey.
Regards
Sandeep
|
|
|
|