Single field entry into two tables?

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

Guest

I have two tables, "Applicants" and "Projects." Each table has a column
called "Name," which are supposed to be the same.

I am creating a form where the user will enter all of the information for
both tables.

Is there a way to have it so that the Applicants-Name field input will
automatically be entered into the Projects-Name table as well?

Thanks
 
Yes, but the field Name is not wholey dependant upon either Applicants or
Projects, so perhaps you need to re-visit the design first.
 
How are applicants and projects related? Can each applicant have many
projects, or can each project be associated with many projects, or both, or
neither? If a record on the One side of a relationship contains the name,
all associated projects on the Many side will also be linked to the name. If
the tables are not linked you can probably use a query as the form's record
source.
 
Back
Top