Form field does not allow data entry; relationship issue?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables with a relationship defined. The form contains fields from
both tables. I cannot enter data into one of the fields. I suspect an issue
with the same number or records in each table, but I am lost. Thank you.
 
Dorothy,

I assume that your form is bound to a query that is based on the two tables?
Can you provide more information about the tables, how they are joined, which
field from which table you cannot enter data into. Do you get any error
messages when you try (either pop-up errors or messages in the status bar),
or does it just not accept any input? How about if you try adding data
directly through the underlying query rather than via the form?

The only thing I can think of off the top of my head without any further
information is that you may be trying to use a foreign key value that doesn't
exist in the primary table, but you should get a message to this effect when
you try and save the record. It should not prevent you from typing anything
in the field at all.

Jon.
 
Back
Top