Grouping prompt question better explained. I hope

[system]

Hi,

Do you need to add ‘Regional’ only to the LOV of State object? Or also as the real value of the State object? That’s different.

If you want to add it only as an LOV value then please have a look at this entry in Designer’s FAQ:

120×120 10.4 KB

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

It discusses how to add a value ‘ALL’ in the LOV. Change ‘ALL’ to ‘Regional’ and you are good to go

---

Marek Chladny (BOB member since 2003-11-27)