Forum Discussion

ells69's avatar
ells69
Icon for Helper I rankHelper I
3 years ago

alternative to merge to retrieve description fields

In M  I have a fact query with many keys in. Lets Call it "Fact". I have several querys that have the matching description LKUP_Product which consists of [ProductID], [ProductName],[Product Colur] ...
Need Help
Tips and Tricks
ells69's avatar
ells69
Icon for Helper I rankHelper I
3 years ago

Think I will try the solution from AlienSx  . This is kind of what I am looking for,. My users are a little crazy and we may need to have these links across multiple tables. I like to keep the data model as simple as possible. That way there is less chance of another Dev making a mess or the user selecting unrelated items (this happened yesterday and it is hard to explain to the user why there is an issue) 
Thanks both

M