Calling a field from another table

Hi Siva,

Could you explain what you are trying to do with that field from another table? Are you looking to pull one value from one record or pull up for example a summary or the most recent record's value, etc?

------------------------------
Evan Martinez
------------------------------

If I've understood correctly, to build a 'vlookup' using the value in a field in Table 2 (assume it's named Field 1) to find a match in Field 8 in Table 1 and pull back the value in Field 9, I think you'd need something like this:

GetFieldValues(GetRecords("{x.EX.'" & [Field 1] & "'}",[_DBID_TABLE_1]),y)

Where x is the field ID of Field 8, y is the field ID for Field 9 and _DBID_TABLE_1 is the table alias of Table 1, which you'll find at the bottom of the advanced settings screen.

------------------------------
Jeremy Anson
------------------------------