I would like to create a form to add info to more that one table.
ContactInfo form (name, address etc) has a contactType field and associated
relationship to contactType table.
The simplest way to do this is to base the Form on a Query joining the
two tables. Be sure to have the ContactType field from *BOTH* tables
included in the query.
It may be safer to use a Combo Box control to enter the ContactType
and use the combo's Not In List event to add a new type when it's
needed (I'd guess that after the first week it usually won't be, but
then I don't know how you use the field...). Search at
http://www.mvps.org/access for "Not In List" for some sample code.
John W. Vinson[MVP]
