The new multivalue field type in A2007 does exactly what I want on a form, but I'm really against using multivalue fields and prefer to handle my many to many relationships with an extra table.
What I want to do is somehow mimic the multivalue popup which allows multiple selection using check boxes.
Example: I have a table items and a table types and I store the many to many relationship in a table item_types (an item can be classed as more than one type). I know I'm going to have to add a boolean field to one of the tables - presumably in item_types?
I'm sure it's a relatively simple thing to achieve but at the moment I just can't get my head around how to do it.
What I want to do is somehow mimic the multivalue popup which allows multiple selection using check boxes.
Example: I have a table items and a table types and I store the many to many relationship in a table item_types (an item can be classed as more than one type). I know I'm going to have to add a boolean field to one of the tables - presumably in item_types?
I'm sure it's a relatively simple thing to achieve but at the moment I just can't get my head around how to do it.
