This content has been marked as final. Show 6 replies
Depends on what you want.. If you want to get rid of the duplicates, it would be best to clean up the table.
If you want to stay with the duplicate data and only supress the display, you could freate a view with a group by or a distinct and base your form-block on that view. You could also do the same with a blokc based on a from clause query
MST wrote:Hi, MST
In my table duplicate records should not delete.
Just i want to show distinct records in front end form
Andreas suggestion is good to follow. Create a view something like
Now create your form database block with the view.
select distinct column_name1,column_name2... from table;
Hope this helps
Keep your original table - Header
Create new VIew without Duplication. - details
Create Master Details Relationship.
This way you can avoid displaying duplicate records without affecting original table.
We have done this our Employee Management application(Custom)
If you are not clear, you provide your table structure here