Jim I cant answer your question, but I can tell how I do. Before bring up a report or form I have a starting form. On that form I give the selectio criteria for example Starting_Date Ending_Date and Customer_number I can then in my eep geneerate the where clause based on user selection For example: where Customer_number = .vCustomer_number and Quotedate between .vStarting_Date and .vEnding_Date You can expand this as you like. I must confess most users in my enviroment would be capable of handling the wherebuilder, in my mind you need to understand the database design to use the where builder. Therefore I prefer to guide my user with a predined selection form less flexible of course but more easy to us for the user.
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Jim Belisle Skickat: den 11 april 2009 14:29 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Button fro the Where builder Is there a code I can write within an EEP (on click) that will bring up the where builder for a specific report or form? I want people to have access to the Where builder so they can check on quotes based on numerous fields. Jim
