Formula for form fields
Hi want to write a formula to show and hide fields on a form which is in Table 3. Table 1 has one to many relation ship with Table 3. (not sure if it even matters) Table 2 has one to many relation ...
Forum Discussion
- If the formula will do the job then, Is this the right formula structure? below is the formula
If (
[Table3_Form_Field1] = "Value1",
Then show [Table1_Field1], [Table1_Field2],
else if (
[Table3_Form_Field1] = "Value2" or "Value3",
Then show [Table2_Field1], [Table2_Field2],