Multiple Users Contributing to One Record via Email

[zga2]

Question:

Trying to use Access' 'collect data from e-mail replies' function to gather information from several colleague. A record may have 10 tasks associated with it.

I want Colleague A to have responsibility for tasks 1, 2 and 3.
I want Colleague B to have responsibility for tasks 4, 5 and 6.
I want Colleague C to have responsibility for tasks 7, 8 and 9.
I want Colleague D to have responsibility for task 10.

I don't want Colleagues to have the ability to change the value of tasks to which they have not been assigned.

One way I could do this would be to set up multiple tables and join them in Access. I'd prefer to have a single table, if possible.

On another topic, does anyone have a good link that teaches how to 'associate tables' in Access? e.g., to facilitate bulk e-mail sending.



Thanks,

Z

[June7]

What is your confusion about associating tables? Tables are associated by primary/foreign key fields. Relationships can be defined to control data referential integrity.

Build queries that join tables in order to retrieve related data.

I haven't actually used the 'collect data' functionality, just a couple of experiments with it. Can't you set up the data email for each colleague so they get only the records and fields they need to review?

[zga2]

Thanks. I know how to build select queries but I'm not clear on how to make 'associated tables' in the context of Step 5 of the Access 'Create E-mail' wizard.

Is that any clearer? Thanks,

Z

[June7]

Access Help 'Start the wizard' Step 2: To populate a single table, select the table in the Navigation Pane. To populate two or more related tables, select the query that is bound to these tables.

Look at Access Help on building queries that include multiple tables by JOIN clause.

Remaining question is will the data collection email include only the records that are filtered by the query?

Time to test and let us know.