Let's say I have created two relates between two tables, each relate is using different relate fields to join the two tables. One relate is relating by Fruit Type, the other relate is relating by Zip Code. Both relates are pointing to my "Sales" table.
When I select my records and click on the "Related Data" button on the ribbon, there are two listings saying the same thing "Sales" and "Sales". I don't know which one is relating by Fruit Type and which one is relating by Zip Code.
When I hover over one of the "Sales" listings, the tool tip that pops up says the same thing as the listing: "Sales"
The problem is that I don't know which one to choose to match my desired relate. Yes, I can try one, see the results, and try the other one, but this is totally unproductive especially if I have more than 2 relates with lots of records. It's slow and can be better.
Instead of redundantly displaying the target table names in the Related Data listing, display the Relate Name to allow the user to differentiate between two relates that point to the same table. The tool tip already shows the target table name if the user desires that information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.