Home » Other » General » child records
child records [message #458150] Thu, 27 May 2010 10:40 Go to next message
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

Re: child records [message #458152 is a reply to message #458150] Thu, 27 May 2010 10:41 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How to I define that?
Combine all 3 into a single table
Previous Topic: Document and Source management system
Next Topic: fatal error U1073: don't know how to make
Goto Forum:
  


Current Time: Fri Mar 29 05:15:10 CDT 2024