Hi there,
I am trying to have a value from a related table populate a field. The tables are related based on related field, but I would also like to grab another value from the related table and populate the field of another table. How can this be done? Look up values are not working for me, I only get a blank value, do I need to calculate this?
Cheers,
Travis
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.