I have a database consisting of 3 tables, the main table with main
contact info, a second table with additional address info and a third
table consisting of additional contact information, or more
specifically 'other names sometimes used to identify the main contact
person'.
I have related the tables, the main contact info table being the main
table on the one side, and the other two tables hold additonal data
and are on the many side.
The tables are related properly. In the main table a number data field
called "List Identifier" distinguishes each contact and is the primary
Key, the tables on the many side relate to this field through a Number
Data Field called "Link to List Identifier." I have built a form with
a subform attached.
The form I've built displays the info correctly however there is one
caveat; for each "Contact name" field in the main or one table there
may be from 1-10 corresponding "other names used" information in the
many table that correspond to the one contact's name in the one table.
[More specifically in the many side table I might have "other name
used 1", "other names used 2", etc in the many table. Say for this
example "other names used 1" and "other names used 2" in the many
each correspond to the contacts name, "John Smith" in the one table.
John Smith's List Identifier is say "10021" in the main table. Each
"other name used" entry in the many table uses the "10021" linking
number in the "Link to List Identifier" field to relate it correctly
to John Smith].
My form displays the first corresponding "other names used"
information in the appropriate field, correctly from the many table.
My question is, how do I display on the form the other, anywhere from
1-10 "other names used" info from the linked table on the many side?
Can anyone assist me with this. Thank you.