[progress Communities] [progress Openedge Abl] Forum Post: Filtered View Based On Sql...

  • Thread starter Thread starter Simon Tregloan-Reed
  • Start date Start date
Status
Not open for further replies.
S

Simon Tregloan-Reed

Guest
Hi All, I'm currently working on an app where I'm in need of a filtered list view when selecting products on a quick create page. My situation is as follows: I have an application where I create a salesorder record. I then create and attach sales order items to the salesorder. I use the quick create page, to create the salesorder item, which has a lookup selector to the products object. I've set the application up so that the products are unique to the salesorder so that it stops duplicate products being added. Instead of alerting the user to the fact that they have selected a product already attached to the salesorder, when they click on the save button to create the salesorder item, I'd like to use a filtered product view page that will only show the remaining products that are not currently attached to the salesorder. I've been looking at getting the filtered view page to work with a formula but seeing how complicated this filtered view will be to get working and how basic the formula textarea field is I have to work with I'm running into issues that I can't debug at all. Any help would be appreciated. Regards, Simon Tregloan-Reed

Continue reading...
 
Status
Not open for further replies.
Back
Top