Database structure solutions for many to many relationships with attributes required to sort by

Well done on discovering an “association class” or “link box” or “join table” or … there are lots of words for this :slight_smile:

So what you can do is the “reverse lookup” …so search for Credit (sorted as you like) and then link to your Join Table to do the filter part.

2 Likes