Entering info once for several value lists

[Ronan]

I'm working on a database that included 5 tasks that will be checked and initialed by the worker that competes them. We want them to choose their initials from a drop down list.

For each of the 5 tasks, there needs to be a drop down list with a list of initials to choose from. I want to keep the list of initials consistent without having to add/delete 5 times every time there is employee turnover.

Is there a way to maintain one list of initials that is used independently by 5 value lists?

 

Thanks!

[Steve Martino]

If you made a calculation field in the worker table for their initials, then based the value list on that field, then you would never have to change the value list.

However, initials may not be the way to do this as they will not always be unique.  Maybe concatenate the initials with a worker's ID, or some other unique identifier.