Look up value? Or Calculation? Enter value from a field in a related table

It sounds like you have three tables involved, no?

Table A is related to table B. You want to get related data from table B and place it into table A. You then want to get another piece of data from table B and place it in table C. Is that right? If so, the most general solution is to use a script to set both values.

Fields in table A and table C could be defined so that their calculated value is updated when a piece of data changes in table A and table C respectively. However, the fields that trigger the update have to be changed manually or by a script.

If you have a field that you have defined as an auto-enter looked up value, and you created that with there already being pre-existing records, then it is quite likely that you will not have values in that new field.  This relates to the way Auto-Enter options work. A helpful explanation is found here:  Calculations and Auto-Enter Calcs | A Filemaker Miscellany

You might need to decide if you want the value in the new field to update automatically if the value in the related table updates, or not.

Relookup Field Contents

Hi Travis.  A calculation will do it well.  Currently your field type is probably text or number with an Auto-Enter option to insert the looked up value.  Change the actual field type to calculation.  Then the field in your first table will always reflect the value from the field in the second.

Hope this helps.  Chris

Hi Travis.  You don't need a get function or anything like that.  You just define the calculation as = TableB::Value (with Value being whatever the name of the field is).  Make sure you specify the result of the calculation as Text (see screenshot).  All the best!  Chris