Unsure of what it is called...

[tallentd]

I am new to Access and have created a database for my company. I have a
situation that I know can be done but I am just not sure as to how to do it.
My business is a church planting organization and I have created a database
of churches and church planters (the one who starts the church). There is
only one planter to a church but a church can have multiple pastors. I would
like Access to populate the current pastor fields in the current pastor table
with the planter data from the planter table if the checkbox that I have
created in the pastor table is set to true which means that the planter is
the current pastor.
Hopefully this makes sense. Any help would be greatly appreciated.

 

[Wayne-I-M]

If there can only every be one planter that makes it a unique property of the
church and so should go into the chaurch table.. You need another table with
Pastor's details. You could link both tables in the relationship window by
the ChurchID (normally an autonumber field) - but I would create a new table
to link both together (tblPresent)

You don't need a current pasture table. You may want to have date arrived
and date departed fields in tblPresent - anyone who does not have a departed
date is still there and so is current.

If the date arrived and church formation dates are the same then the person
is the seeder so no other fields (tick box) are needed.