I have a MASTER table (the one) that has an existing relationship to a DETAILS table (to the many).
MASTER(one) < DETAILS(to many)
There is one field stored in the DETAILS table, i.e. [NeedThis], that I need to reference in an exact form using field IDs (FID) from the MASTER table.
Is the only way to get that DETAILS field data into the MASTER table to create a new reverse relationship? ...so I can create a new lookup field using below relationship? Or is there an more efficient way to do this?
DETAILS(many) < MASTER(to one)