Help with Dynamic Checkbox

[kbc1]

Hi

I have a table in my database which stores locations from around the world(locations_table.id is the primary key). This table can be edited and new records added etc via a web page which is fine.

My problem lies when I create a new record in my 2nd table (via a web page) and while adding this record I need to be able to select multiple locations that the record is associated with (i.e. the use of checkboxes would seem ideal).

I can retrieve the locations and display them dynamically on screen which is fine but it is the saving of the data back into the database which I need help and advice on how to do as I believe all of the location.id's would have to be saved into one varchar field like '1,2,3,4' etc

If anyone has any advice on how to approach this I would be grateful.

[devinemke]

what you have there is a typical many-to-many data relationship. the common way to do this is to have a third table that stores the links between the other two tables using the primary key fields from each table.