Calling a field from another table
How to write QB formula that will pull up the record from another table field? Table 1: Field1, Field2, Field3 Table 2: Field4, Field5, Field6 .[Field6]= .[Field2] ---------------------...
Forum Discussion
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
------------------------------
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
------------------------------
@Siva Bhandar if there is a relationship between Table1 and Table2 you could use summary or lookup fields to get the values onto the same table for your formula.
Otherwise, Jeremy's example is what you're looking for.
For more information on Formula Queries, I put together this video ⬇
------------------------------
Quick Base Junkie
------------------------------
Otherwise, Jeremy's example is what you're looking for.
For more information on Formula Queries, I put together this video ⬇
------------------------------
Quick Base Junkie
------------------------------