Is there any way to use the table field, populate it with records and then use one of the fields from one of those records in a calculation?
Or perhaps a better, more appropriate approach would be to have a separate form in which these records are kept and then use the Link to Form to extract the single record that I am after.
Unless I hear differently, I will work on the second approach.
The Table field can have a Calculation field in it of course. But the parent form is not able to pick out an individual record from a Table field in order to obtain a specific value. You can only get the results in aggregate.
That’s what I thought, thanks. With the new Join option, getting a single value out of records in a linked form is quite straightforward!
.
