I’m struggling with a concept that I suspect is quite straight forward and hope you guys can help:
I’m attempting to recreate our invoicing system from google sheets for my team of artists - we charge our clients based upon the title of the artist, at the various negotiated rates for the project. This means a two axis “lookup”.
Here’s my mock-recreated data set:
The Name and Project columns in the Test-Timesheet table are look up columns from the other tables.
My Current Understanding of Lookups
If I’m understanding this correctly, the look up is returning the data of the entire row, meaning that referencing Project.Junior would return the Junior rate. I’ve done this successfully for the Title column by using Name.Title.
My issue is that I don’t know how to reference a variable column - in the timesheet above, I need to look up the column within the Project lookup based upon the Title of the artist who performed the work. Can someone guide me on how to query this data correctly?