I would like to set a flag in a record if the record key exists in another table. Can anyone tell me how I can do this?
Specifically, I have a volunteer master table and a task table. If the volunteer number exists in the task table, I would like to set a field in the volunteer table to "yes" so that I can run a quick report or extract of all volunteers who have been assigned tasks. I only want the volunteer to show up once on the report, regardless of how many tasks they are assigned. I tried a query joining the volunteer table with the task table, but could not suppress duplicates using the option in query design.
Thanks in advance for any help on this.
Linda