I have a database which I would like to track if the delivery date for a given VFX shot changes.
I have a "Shot Record" layout in a "Shot Record" Table. I have another table called "Vender Status Report".
Each vendor sends a weekly report which gets ingested into my database in the "Vendor Status Report" table. I have a shot layout in the "Shot Record" table which I do most of my work in. In that layout, I have a tab which displays related info from the "Vendor Status Report". It shows all the delivery dates and the table is sorted by the vendor report date. I'd like to see if it's possible to have a field in the "Vendor Report" table that is a calculation which checks if the delivery date is the same as the delivery date in the last dated report. Is that possible? Is there a "If" calculation that can match a field to a related entry against the previous dated record.
The attached image is of the tab in my "Shot Record" layout of the related "Vendor Report" table.