Checkbox group - how do they work?

How do checkbox groups work? I think I have a need to use them!

I need to create a table of facilities for venues, and as more venues are added, I am sure more facilities will be added, so I am going to have a table of facilities. I was then hoping to be able to take that table and apply them to an insert and update page in data assist, but the wizard doesn't allow me to link the table to the page... it doesn't allow for dynamic data like a menu does, so how do I link this table to the pages that require it?.

Also, I am assuming that if I have a 20 facilities across all venues but each venue doesn't have all facilities, then I will be able to store the ID's of each facility as comma separated strings in a single DB field e.g.: 2,4,5,9,12,15

It seems there's two stumbling blocks (in my head anyway) with regards to this. The first is the insert/update pages, the second then being how to display the data once I have it inserted in the DB. I will need to separate each number into their own piece of info rather that means something to the viewer rather than display a string of numbers and commas.

I have read previous posts with regards to checkbox groups and tried to find the info in the help files, but can't see how they are implemented in data assist.

Thanks

You will nee to use a linking table and the Manage relational table behavior for this.

see the following tutorial:
http://www.webassist.com/tutorials/Manage-relational-tables

A checkbox group is the wrong thing for this then?

That's a monster of a tutorial isn't it? I've often wanted to find a reason to use the RTM tool to find out how it can be utilised, and now I have a one

That's correct, a checkbox group is not what you want to use, though you will be using checkboxes.

Having just read it without actually carrying out the exercise, I understand what is going on there, but I am left wondering what happens if one of the venues needs to remove a facility, does the RTM tool handle the deletion of rows too?

you would update the venue to uncheck the facility that it no longer relates to.