Linking tables/relationship

[Access SS]

I am creating a mailing list, which will be composed of five different
"customer" lists (one will include a list of ccurrent customers, one will
include a list of prospects...). Each customer list is managed by a
different individual in our office, and all individual customer lists contain
the same fields. One of those fields is the "source", which designates where
this record came from (prospect, current customer...). When each individual
needs to make edits to their list, I don't want them to have to view the
master table, but a sub-table with only their customers (prospect, current
customer...). When they make their changes, I want the changes to
automatically appear in the master table. I'm thinking this has to be done
either by linking or with a relationship. Any advice would be appreciated.

 

[KARL DEWEY]

Have you considered using a single table and making use of that "source"
field so that the other individuals, with criteria in a query, only see the
records that apply?

 

[Access SS]

That's exactly what I need, thank you.