Ref_Rows for label not key

[Joshua_Giles]

I would like to make a Ref_Rows formula that shows all related transfer requests for specific Equipment IDs. However I can’t make the Equipment ID’s the key of the transfer requests but I can make it the label. The current formula is: REF_ROWS(“Transfer Log”, “Equipment ID:”) which returns blanks because as the test shows:

The list of values of column ‘Key:’
…from rows of table ‘Transfer Log’
…where this condition is true: ((The value of column ‘Equipment ID:’) is equal to (The value of column ‘Key:’))

It should say:
The list of values of column ‘Equipment ID:’
…from rows of table ‘Transfer Log’
…where this condition is true: ((The value of column ‘Equipment ID:’) is equal to (The value of column ‘Equipment ID:’))

[Marc_Dillon]

You have to use the key column in the ref_rows function, because that is what establishes the reference between a record in the Transfer Log table, to a record in the equipment table. The Equipment ID column in the Transfer Log table does not have to be the key (and it should not be), nor the label… it has to be a ref type column that points to the Equipment table.

[Joshua_Giles]

It’s always the simple fixes that amazes me! Thanks @Marc_Dillon