form query links tables, trouble with indexed common field

J

J@50N-5ALTR

Hi everyone,
I have a form composed of fields linked by query involving several tables.
The tables all have their own distinct primary key field, and one common
field that is indexed with no duplicates. WIthin the query this common field
is linked from a table of origin to all the other tables.
Now, when I open the form based on the query, all the fields are visible
and I can enter data into them all. When I create a new form record the
"Error 3022" message appears.
I need some help with how to debug this problem.
Thanx for reading and helping.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top