Records Help Please!

[Guest]

I have 3 tables , one "Guests" table inserting guests details and another
"Songs" table that will be populated with names of chosen songs stored on
"Artists" table. Guest input name and email and the the DB Guest ID columm
updates and autonumber. Guest selects tracks from "Artists" table, any number
of tracks, 1 or more of up to 50 choices. "Songs" table insert names of Songs
ID columm in the same Guest ID number, not changing Guest ID number until new
login.

I only now how to create one record input at time and the tables are updated
without links. Can someone please tell me how to do this in Dreamweaver. I
have already spent the last 72 hours trying, please help me here!

thanks

ted

 

[John W. Vinson/MVP]

I have 3 tables , one "Guests" table inserting guests details and another
"Songs" table that will be populated with names of chosen songs stored on
"Artists" table. Guest input name and email and the the DB Guest ID columm
updates and autonumber. Guest selects tracks from "Artists" table, any
number
of tracks, 1 or more of up to 50 choices. "Songs" table insert names of
Songs
ID columm in the same Guest ID number, not changing Guest ID number until
new
login.

I only now how to create one record input at time and the tables are
updated
without links. Can someone please tell me how to do this in Dreamweaver. I
have already spent the last 72 hours trying, please help me here!

You need ANOTHER TABLE.

If you have a Many (songs) to Many (guests) relationship, you need a
"resolver" table to model the many to many relationship. It should have a
field for the GuestID and for the SongID; rather than repeating information
from either table, you would simply add a new record to this table. It's
convenient to use a Form based on the guests table with a Subform based on
the resolver table, using a combo box to pick the song; see the Oreders form
in the Northwind sample database for an example of how this is done.

John W. Vinson//MVP