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:โ))
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.
Itโs always the simple fixes that amazes me! Thanks @Marc_Dillon
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |