Why is this calculation not permitted (and what’s the replacement)

[fmow]

Get(CurrentLayout)::FieldName

 

Why can I not do this and what should I try instead?

[jbante]

The syntax for a fully qualified field name begins with the table occurrence name, which is not necessarily (or even usually) the layout name. Also, assuming that you're trying to build a calculation that will return the contents of a standardized field that has the same name in all your tables, you would need to be concatenating the the table occurrence name with the field name for an initial text result, and giving that text to the Evaluate or GetField function. A simpler alternative is to just use the GetField function:

GetField ( "fieldName" )

The GetField function will assume you mean to get that field from the current record, in the table occurrence the current layout is based on, so it's OK to leave the table occurrence name out altogether in this exception.

[Rick Whitelaw]

There is no function Get(CurrentLayout) for starters. Use Get(LayoutTableName)&"::YourField"

[fmow]

points taken, thanks guys!