duplicate data in dropdown menu

Hello, 

i have a question. I made a simple data base with a simple form
I get duplicate data in the dropdown menu.

Is there a simple way to show only unique records ?

Management.oml

mvp_badge
MVP
Solution

Hello Toine,

Hope you're doing well.

So I was checking your code and you're referring to a problem in your Merk dropdown, in InfluencerDetail screen.

This dropdown is bound to a list, in this case GetMerks.List.

It seems that you're doing several unnecessary joins (with Influencer and Influencer_ext entities) that may cause that behavior.


I removed those joins, leaving only Merk entity (like you have in Merk screen).

Please refer to attached OML file.


Let me know if it worked for you.


Kind regards,

Rui Barradas

Management.oml

thank you very much

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.