Hi, all.
Using Access 2K. I think what I'm trying to do is quite simple, but
I've been out of the loop for a few years so I've forgotten much.
I have a table of records each of which can belong to multiple
categories. I have a table of all the categories available.
I have a crossreference table which links records to categories.
What I want to do is have a form for the records, with an unlinked
subform which displays _all_ the categories, with a check mark next to
the ones which have a crossreference record. If a checkbox is checked,
a new crossreference records is created. If a checkbox is cleared, the
crossreference record is deleted.
I'm not entirely sure that the way I'm planning to do it is
particularly efficient anyway, but at some point I want to enable
"triple state" for the checkbox, the "grayed out" state indicating
where the category was added after the record, so the system "doesn't
know" if the record belongs to the category.
Does anyone have any comments or examples of how I can better do this,
assuming it's not already being done appropriately.