I am working with an Adobe form, and need to format a field to select a value from one of three other fields. The other three fields have dropdown lists from which to populate the individual fields, and I need to be able to select one of these three values to appear in the fourth field. Data in these fields are not based on calculations, but on personal choice selections from lists of options.
First write out in long hand what it is that sets the criteria for the value that is displayed in the field that needs to show info from one of the three other fields.
If FieldA is X, and FieldB is NOT Y, and Field C is NOT Z, then show value.FieldA in FieldQ