Best way to maintain similar choice list fields on different tables?

[Sergio24]

Hello,

Anyone can suggest a best way to maintain similar choice list fields on different tables?

We have a custom choice list field on de Demand table (dmn_demand) with choices A,B,C..

We now want to have the same choice list field on the Project table (pm_project).

I think I have two options after creating the choice list field on the Project table:

1- Create all the same choices within the choice list field

2- Link the choice list field to the one of the Demand table, so I don't have to create again all the choices.

My first guest would be to choose option 2 so I don't have to maintain the choices of two fields if a new choice is added.

However I don't know if this could create problems in the future or if it's even a good way to go.

Or maybe there is another way beside the options I mentionned?

Thank you

[Chuck Tomasi · Accepted solution]

Hi Sergio,

The easiest way is to decide which is the "authority" and use the dictionary entry on one to point to the "authority". I do this all the time.

Is it going to create problems in the future? Only if someone wants different choices on each one, but then you can break the link and create independent choices at that point.

[Sergio24]

Hello Chuck,

When you say 'decide which is the "authority"' do you mean, for example, the choice list field on Demand will be the one to always maintain fo adding new choices? And then if other tables need the same choice list then point to the Demand choice list?

So this would be my option 2?

Thank you

[Chuck Tomasi]

That is correct.

I might also suggest that this is a good use of the Comments field on the dictionary entry. It may not be available on the form OOB, but it's a good time to put it on the form and make a note in the other tables' choice list fields "Values from this choice list come from dm_demand" to help your "future self" and those who maintain the system after you!

[Sergio24]

Thank you very much for your wise answer!