The main data is real estate transactions and a property has a three letter code associated with it. That code then has multiple descriptions. A property could be "retail" and "net lease", for example, so the lookup table would have the three letter code in it twice, one for "retail" and once for "net lease". There will also be many different codes for each one of the descriptions. For example, there many be 30 or not codes with "retail" as a description but many of those will be elsewhere in the data one or more times with additional descriptions.

I'd like to be able to set up the data or create a connection between the data and the lookup table that would allow me to filter using the "description" ("retail", "residential", etc.). So the same property could show up if filtering by "retail" or by "net lease"

I think my original explanation and the example data does a good job of representing the many to many relationship, but I hope this gets me an answer!