Scott, before i hurt my head too much on this, are you aware that you do not need to have a relationship to have a Report Link field. You can make a report link field on any table and then all you need to do is to have any field to match on. For example for the first requirement that
Garage Able:
Project A for 2018 in the list of current and past project
On the Report Link field you will create you would be setting up a match between either the [Record ID#] of the Garage or the name of the garage with a similar field on the Work Orders. Any project info you need would come down form the Project record down to the Work Order. Does the Work order have a field on it for the garage name or the related garage?
