How do I get one record if it has the same multiple by clicking smart field and shows on...

Hello OpenEdge/Progress 4GL!!!

I think I need an idea from you. I have created a smart viewer window and added smart fields on it. Whenever I click on then it takes a data directly from db every time.

But the concern here is i could have same multiple data and should see only one from them.

Let me share what i set it up

/* Under Dynamic Lookup - Smart Fields */
/* Base query string */
FOR EACH part NO-LOCK INDEXED-REPOSITION
Key Field: Part_obj
Displayed field: part_id
Fieldlabel: PARTS LIST
Browse title: Lookup


/* This is a setup that we can do in smart field instance properties*/


As you see above base query string is FOR EACH in dynamic look up so that its shows all the data even if it is found the same multiple data

Could you please help me to filter duplicates if its possible in dynamic look up?

Continue reading...