Stacking LOV's

Anyone know how to stack LOVs…i.e. a LOV for Zip Code might first prompt you for County Cd first ? (BO 5.0)

Thanks.

Kathy


Listserv Archives (BOB member since 2002-06-25)

Kathy

You can edit the SQL associated with the LOV and customize to do just what you are trying to do. Do this by adding a prompt for the County Cd in the “where” clause for the Zip Code. Then when the LOV pops up have the users hit the “refresh” button to invoke the modified LOV query to get prompted for the County Cd.

Mike McErlain
McErlain Consulting
MikeMcErlain@Netscape.net

At 03:19 PM 4/5/2000 -0500, you wrote:

Anyone know how to stack LOVs…i.e. a LOV for Zip Code might first prompt you for County Cd first ? (BO 5.0)
Thanks.
Kathy


Listserv Archives (BOB member since 2002-06-25)