If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking tables/relationship
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. -- Access SS |
#2
|
|||
|
|||
Linking tables/relationship
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? -- KARL DEWEY Build a little - Test a little "Access SS" wrote: 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. -- Access SS |
#3
|
|||
|
|||
Linking tables/relationship
That's exactly what I need, thank you.
-- Access SS "KARL DEWEY" wrote: 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? -- KARL DEWEY Build a little - Test a little "Access SS" wrote: 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. -- Access SS |
Thread Tools | |
Display Modes | |
|
|