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

[Akshay Bhonde]

Hello Chuck/Sergio,

I found this article when I was going through same situation and looking for some solution.

But I did not understand the solution you have provided : "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."

Can you please explain it little more and how I can do that.