Copy Data from a Related Field

[wmugrad28]

I'm trying to get the value from a field in a TO into a related table's field. I need to have this field show live data and be able to be part of a relationship match field. I tried setting the field as an unstored calcuation. The calc. I used was GetField(nameofrelatedfield). Every field has a ? in it. I do not want to use a script if possible.

Greg

[Vaughan]

"I'm trying to get the value from a field in a TO into a related table's field. I need to have this field show live data and be able to be part of a relationship match field."

Cannot be done.

In order for the data to be "live" you'll need to make an unstored calculation based on the related field. But unstored (unindexed) fields cannot be used as the remote key for relationships.

Lookups (or in FMP 7 use Auto-enter) are often used for this, but the data is not "live" in as much as the looked-up field does not automatifcally change whenever the source field is modified. This can be solved by scripting an update process.

[wmugrad28]

I think I've got it. Thank you.

Greg