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