Using a calculated field name?

[Tom Kennedy]

I have a field called ClientID in many tables. I want to access that field name using the same code but in different tables. Thus far I have tried different variations of the following without success:

Get ( ActiveFieldTableName ) & ": ClientID"

Any help will be appreciated.

[comment]

What exactly does "access that field name" mean? IOW, what are you trying to accomplish?

[Tom Kennedy]

I want to use code like in my example in 'If' statements and to set global variables regardless of which layout I am on.

[comment]

I still don't see how this would be useful, but

GetField ( Get ( LayoutTableName ) & "::ClientID" )

will get you the value in the ClientID field of the current record in the current table.

Note that this will break if you change the field's name (unless you have version 10 and can use the GetFieldName() function).

Edited April 17, 2009 by Guest