Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Switching from One-to-Many to Many-to-Many structure

Switching from One-to-Many to Many-to-Many structure

Thread began 4/25/2014 5:47 am by iainmacdonald331081 | Last modified 4/25/2014 9:13 am by iainmacdonald331081 | 723 views | 3 replies

4/25/2014 8:43 amJason ByrnesWebAssist

Yes, you need a 3rd table to act as the linking table.

you should have 3 fields:
lodgeuserID - primary key
lodgeuserUserID - relates to the tbl_Users.UserID
lodgeusersLodgeID - relates to tbl_Lodges.LodgeID

I Would not copy an existing table, I Would just use your MySQL GUI Tool to create the new table and define the columns.

you should look into the manage relation table tutorial:
http://www.webassist.com/tutorials/Manage-relational-tables

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.