Field data from another field?
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