Reverse Lookup to Table

[Bobby_Ritter]

Hello everyone,

You may want to consider this schema when working with this problem, thanks!

Many to many with lookup

Hello @Aaron_Westberg, Since this is currently not avaliable (and may never be given the complications of having such 2-way sync as described in other posts), have you considered building the relationship like this? Each table would have a direct select option to the other table, and you would use the “All Related” columns for all of your doc reporting, formulas, etc. when you need to access the entire many-to-many relationship. I hope that helps, thanks! Edit: Switched the lookup columns t…