AnsweredAssumed Answered

Field data from another field?

Question asked by jackmac on Jan 21, 2013
Latest reply on May 27, 2013 by MICHAELAE-V

Title

Field data from another field?

Post

     Hopefully an easy one for one of you genuises out there... it's stumped me I'm afraid.

     I have a system with two tables. I want one of the fields in table 2 to get it's content from a field in table 1. The table field only has data with three choices and is strictly limited to those three.

     I want the field in table 2 to look at that table 1 field and extract only 1 of those values. If any help I can send a diagram but hopefully I've put it across well enough.

     The field in table 2 to look at the table 1 field and say:

     if table1::field='value', show in table 2::field

     Thanks

      

     Jack

Outcomes