Field where choices can only be used once - please help!

cynlink1
Tera Expert

I have been asked to create multiple choice list fields where the choice options can only be used once similar to rating lunch options in order of preference. You cannot have two first preferences.

 

Lunch          My Preferences

ChickenSecond preference
BeefThird preference
VegFirst preference

 

I need to create a input method to capture data similar to the table below. In each column, each value must be unique. For instance, users should not be able to rate Cost as the 'Highest' for both Avoid and Mitigate.

 

I was planning to create a new table to store records representing each row (Avoid, Mitigate, Transfer, Accept) and then creating fields (columns) for the various ratings (Cost, Disruption, Ability to Implement, etc.) 

 

Few questions for the community:

 

1.) In a parent/child relationship, is it possible to restrict the use of a choice option once it has been used in another child record? 

 

2.) If you have ever fulfilled a similar requirement, what did you works the best. I am open to any idea you are willing to share.

 

3.) Is it possible to create a chart like the example below on the parent form to capture the users ratings and ultimately use the rating values to derive priorities?  

 

 CostDisruptionAbility to ImplementEffectivenessEfficiency
AvoidHighestMost DisruptiveHighestHighestHighest
MitigateSecond HighestSecond Most DisruptiveSecond HighestSecond HighestSecond Highest
TransferSecond LowestSecond Least DisruptiveSecond LowestSecond LowestSecond Lowest
AcceptLowestLeast DisruptiveLowestLowestLowest
1 REPLY 1