Populate 2 tables from one form

[DavisGail]

I have an Access 2003 database. I have two tables. One table stores all
personnel. The other stores only those individuals that are supervisors and
have certain authority.

I have a form that allows you to enter new personnel. I want to have a
check box that states "is this person a supervisor"? If yes, I want it to
populate the Supervisors table.

How do I go about this?

 

[Maarkr]

You don't want to have two tables to store people info. One table should
have all personnel, with a field to designate if they are a supervisor. To
view supervisors, use a query as the form source to filter the personnel with
the supervisor designation. You may have another table with a list of
authorities that relates to the main personnel table.