sually, it is YOU that creates relationships between the tables. Since
your tables reflect the data, the relationship(s) reflect the data. What
are the relationships between your two tables?
Based on your description of 'repeating fields' (i.e., "Audit1, Audit2,
Audit3"), I suspect your table structure is an attempt to replicate a
spreadsheet, rather than use the relational design available in Access. In
fact, unless your tables are well-normalized, both you and Access will have
to struggle to make use of Access' relationally-oriented features/functions.
Until the table structure is cleaned up, it doesn't make much sense to be
working on cleaning up the forms/procedures...
Folks here in the newsgroups are largely volunteering their time. If you
need someone to help you build an application, you may want to look to hire
someone. If you have specific questions about what you've already
done/tried, this is a great place to post them.
Microsoft Office/Access MVP
"buscher75" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...