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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
