I have two tables for tracking tool inventory/locations. โTool Transferโ is filled out as a form to track when and to where the tool is being transferred. I then have a โCurrent Tool Locationsโ table where I want to just show where each tool is currently. I have the following virtual columns in Current Tool Locations:
Related Tool ID
REF_ROWS(โTool Transferโ, โTool IDโ)
Most Recent
MAX(SELECT([Related Tool ID][Timestamp], true))
Current Location
LOOKUP([Most Recent], โTool Transferโ, โTimestampโ, โTransferring toโ)
The problem Iโm experiencing is with the Most Recent column. The timestamps being returned are not always the most recent. When I test, the list that itโs returning from SELECT() has the same timestamp several times, when they should all be unique values. (Returning 3/7/2019 when the most recent was actually 3/26/2019)
@McKenna_Killion
I believe use of MAXROW()
expression could be more beneficial in your case. As it will return the key column value, you will also have the chance of using de-ref expression to retrieve another value from that referenced table. You can read the further details from this page:
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |