L
Linda1485
--------------------------------------------------------------------------------
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.
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.