I created a generic inquiry that is a custom WIP report that pulls data from the construction module -PMProject and PM Budget Tables.
I wanted to add a column that shows payment made to date for each project. To avoid it duplicating the contract amounts etc for every invoice, I create a separate GI that just provides a list of Active projects ID, Description and total amount paid to date.
I added the GI above to my tables for the WIP report but what I can’t figure out is how to link them in the Data field Links for Active relation window. The parent field is would be contractID but in the child field there are no options for the GI Table. I tried just ContracID or picking the PMProject.ContractID field which is on the GI being used as a table but all I get is error messages.
