Relate using multiple fields

[Bud]

It would be great if we could create relates using multiple fields.

For example, I have a ROLL_UP_VW database view that has ASSET_CLASS, EVENT_STATUS, and YEAR_CON fields.

I want to select a ROLL_UP_VW record and point to the related records in a PROJECTS table (via the ASSET_CLASS, EVENT_STATUS, and YEAR_CON fields).

(I want to edit the related records in the PROJECTS table.)

Currently, only single-field relates are possible with the Add Relate tool. Could multi-field relate functionality be added?

Similar post: Joins based on multiple fields

[Bud]

Relate from table to table joined to query layer