One form, two tables

[Guest]

I have two tables: People and Institutions. I created a form using some of
the fields from both of the tables. The form will not let me enter new
information in any of the fields fron the People table because, "join key of
the table 'tblPeople' not in recordset." What does this mean? What can I do
about it?

 

[John Vinson]

I have two tables: People and Institutions. I created a form using some of
the fields from both of the tables. The form will not let me enter new
information in any of the fields fron the People table because, "join key of
the table 'tblPeople' not in recordset." What does this mean? What can I do
about it?

How are the tables related? Does one person have a connection to a
single institution, or perhaps to multiple institutions? Does one
institution involve multiple people, or just one?

You seem to have made the very common mistake of starting your design
with the Form rather than building a good foundation of properly
normalized tables. If you have two unrelated tables, then Access has
no way to know which record in the People table goes with which other
record in the Institutions table, and therefore which record to
update.


John W. Vinson[MVP]