S
Sean S - Perth, WA
Hi all,
I have an edit form for records that belong to numerous categories. Records
are joined to categories with a join table in a many-to-many relationship.
When displaying a record for editing I loop through the category recordset,
looping through the entire join-table recordset for each category, to tick
(or not) each checkbox as it's displayed.
This seems like a costly way of populating checkboxes.
Is there a more elegant solution?
I have an edit form for records that belong to numerous categories. Records
are joined to categories with a join table in a many-to-many relationship.
When displaying a record for editing I loop through the category recordset,
looping through the entire join-table recordset for each category, to tick
(or not) each checkbox as it's displayed.
This seems like a costly way of populating checkboxes.
Is there a more elegant solution?