Finding FieldValue from a specific table in script

[zakpullen]

Hi,

Is there  a way to specifiy the table the field value should be returned from? This line is from a master calendar.

Max(FieldValue('PeriodDate', RecNo())) as MaxDate

Many thanks

[rubenmarin · Accepted solution]

Hi, FildValue() uses all values of the field, witout specifying the table. In the table you want to retrieve values you can add a field like "PeriodDate as PeriodDateCalendar" and use this field to iterato through it's values.

Also you can do a resident load but it will be slower if the table has many records.

[zakpullen]

Thank you!