I have a canvas app gallery from a table named "Grain_Transfers" that I need to display a lookup field in that table called "Contract_ID". The lookup is tied to a table named "Contracts" and the field in that table is also "Contract_ID".
The goal is to simply display the saved "Contract_ID" field value listed in the "Grain_Transfers" table.
I realize that the gallery doesn't support this directly.
I've tried several possible solutions, but am just not getting something right as I can't get this working.
Thanks in advance for any assistance.