I have a table named Rides, which I first set the Origin column. Then on Ride reports, I made a many-to-many relations using a middle table. They work fine. For the final part, I want to do a relation to Rides, it works, but shows the origin. I want to change that and moved the Date column to be the first column on the left (Second, first is actually Row ID), but it keeps showing Origin. I moved another column, same result. I deleted the relation column and made another, the same. Any advice?
Do you absolutely need a specific column to be shown on that relation though?
If you need the “value” of that column, you can do a lookup on top of the relation.
Not really but it’s clearer if it’s a more unique value than the point of origin, when relating. I’ll do a lookup I guess. One more column 
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.