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
>
>
