I have 2 tables - 1 is Document master, and 2 is Document Revision. A master document can have many revisions, so i setup a 1:N relationship by adding a lookup field in the Document Revision table.
I have a Canvas app with a gallery control linked to a collection based on the Document Master table. I want to include the latest dcoument revision number from the linked Document Revision Table.
I am confused because the lookup field is in the Document Revision table. How do i pull data in the opposite direction (from the Master Document table). The relationship was created between the 2 tables. I am just not sure how to reference it from the Master Documents Table (no field)
Thanks
Dave