Albert:
Thanks for the great suggestions!
Let's assume my parent table is a table of businesses. My child table is
the states in which they reside.
To use the sub-form approach, it seems I would define my "States" table as
the source of the sub-form, and each line in the states table would point
back to the main table using a foreign key.
So, if the main table had two records, key 200 and 201, then the States
table would look something like this:
CA 200
OR 200
WA 200
NY 200
CA 201
MN 201
AZ 201
And so on.
Does this seem reasonable?
--
Rich Locus
Logicwurks, LLC
"Albert D. Kallal" wrote:
The issue here is that you can use a list box or a sub-form to create a
classic relationship.
You don't unfortunate have the same user interface control (I wish they put
that new control in the design tool box).
In the case of a multi-select list box, you can create a very similar
looking effect by creating a sub-form with two columns, one a check box, the
other text.
Take a look at the screen shots here, the 1st form has what looks like two
list boxes, but on the right is a sub-form with a check box.
http://www.members.shaw.ca/AlbertKal...icles/Grid.htm
For a multi-value combo box with a drop down of check boxes one could launch
a small popup form with the above continues form (or data sheet) idea. So
you can create a fairly close interface here, but I do wish that new control
was exposed for our use. I quite like it....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada