Using a form to update multiple tables

[cooperd]

Can I use a form to update a field that is the primary key
in one table and a foreign key in another table without
having to have the user enter the information in twice?

 

[Guest]

Try setting the record source for your form as a query
that pulls the relevant fields from both tables, and
reinforces the relationship that you have set between
them. If the two fields are related in the query, they
should both update simultaneously.