List:General Discussion« Previous MessageNext Message »
From:Stuart Felenstein Date:October 4 2004 7:46pm
Subject:Tying records together across mulitple tables.
View as plain text  
I've worked through some of this but still would like
some opinions.  Maybe it's not clear but I haven't
received any responses.  

Basically to tie the records together I will use the
recordID (auto incrementing) in every table where the
records are written. 

Then I can grab everything out of that recordID.



> I'm not sure , can't resolve in my mind if this is a
> M2M or something else.  
> 
> I have 5 tables, users may enter multiple records in
> each table.  The only trick is (for me) is how to
> tie
> a unified record together across all of them.
> I'll try to  illustrate, and only use 2 tables to
> keep
> it brief. 
> Table1 - Bob has 3 records
> 1st record - Spoken Language is Spanish
> 2nd record - Spoken Language is French
> 3rd record - Spoken Language is English
> 
> Table 2 - Bob has 3 records
> 1st record - I am Spanish
> 2nd record - I am French
> 3rd reocrd - I am English
> 
> Okay the table strutures:
> Table1                    Table2
> RecordID (int, autoinc)   RecordID (int, autinc)
> MemberID (int)            MemberID (int)
> Language (varchar)        Nationality (varchar)
> 
> I'm trying to say here is a record , that would form
> the result of I am Bob, I speak English, I am
> English
> 
> I know, this probably sounds a bit weird :)
> Best way I can come up with right now to illustrate.
> If someone was searching through records, they would
> say I found someone who is Spanish and yes, they are
> Spanish.  Not, I found someone who is Spanish and
> they
> speak Spanish , French and English.  
> 
> I considered (as this is part of a web site)
> generating an ID and then passing it into each table
> entry as the forms (that comprise the process) are
> submitted.  Just to clarify, 5 tables - 5 forms ,
> all
> part of 1 "web entry".
> 
> Stuart
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=1
> 
> 

Thread
Tying records together across mulitple tables.Stuart Felenstein3 Oct
  • RE: Tying records together across mulitple tables.David Bevan4 Oct
  • Tying records together across mulitple tables.Stuart Felenstein4 Oct
    • Re: Tying records together across mulitple tables.SGreen4 Oct
      • Re: Tying records together across mulitple tables.Stuart Felenstein5 Oct
        • Re: Tying records together across multiple tables.SGreen5 Oct
          • Re: Tying records together across multiple tables.Stuart Felenstein6 Oct
            • Re: Tying records together across multiple tables.SGreen6 Oct
              • Re: Tying records together across multiple tables.Stuart Felenstein6 Oct
              • Re: Tying records together across multiple tables.Stuart Felenstein6 Oct