Also additions can be problematic, if you have a linked table in a one
to many relationship and you must have an entry in the One to be able
to create a record in the many - you may run into problems.
You probably want to change your form to relate to the main table only
and use subforms to tie the linked tables to it. In this fashion you
can update the underlying tables in the subforms (access will allow you
to link tables between form and subform) and be sure they meet the
relationship requirements.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/