Conditional "Tabbing"

[EasyEdE]

I am looking for a way to either tab to different fields depending on the value of a given field, ie if Field A is "x" then go to Field B, if it is "y" go to Field C, but I do not want the user to have to click on a button. Field A will be a set group of selections from a value list.

If this can't be done then is it possible to have one field (or set of fields) appear in lieu of another based on the value of Field A? As before, I'd like this to be "automatic" without the need to click a button.

TIA for any feedback.

EasyEdE

[Pupiweb]

Use the so-called "portal trick":

create a Constant field, calc = 1

create a series of numeric calc fields based on fieldA ... for example

ApplesKey: If (FieldA = "apples";1;0)

OrangesKey: If (FieldA = "oranges";1;0)

make several self relationships, joining each calculated field to the Constant field

Put in the layout a portal for each relationship and place inside one fieldB (if you want fieldB to be filled when FieldA = apples) and place inside the other fieldC (if you want fieldC to be filled when FieldA = oranges)

Now, when you enter data in fieldA only one of the two self join relationships will be true, and the field in the portal will appear in the layout, while the other relationship will not be true, and the field will remain hidden

Putting fields in consecutive tab order will let you go to the proper field without having to click on any button

HTH