Multiple work areas in on person record

[pmcginn]

I have a volunteers database but some of the volunteers are working at multiple sites - how do I achieve this in access - they are appearing as multiple records at the moment

[rpeare]

sounds like your database is not normalized

What you'd really need is a table for your volunteers, a separate table for your work sites, and a third table that tracks which volunteers are going to which sites (contains the FK to both VOLUNTEERS AND WORK SITES).

If you're doing it on a single table you're going to continue to have that problem until you normalize your database.