RE: Windows Query - fast development tools
Posted in 1994
Topics: Performance & Tuning, Connectivity: ODBC / JDBC / .NET
>What is the best tool for creating read only, forms based queries on PCs >running Windows that you have run into? > >Specifically: > 1. Order inquiry - Show header and 1-n detail lines > 2. Invoices > 3. Shipments > 4. Automatic drill down capability - i.e. show summary records for >customer sales and then be able to drill into individual records making up >summaries. You can use Microsoft Access and ODBC to do this.. Access has a forms wizard that will help you create forms with embedded subforms (master-detail type of forms). Additionally, the Access Developer's Kit has an OCX (Ole Custom Control) that let's you *easily* setup drill-down capabilities (up to 16 levels deep!) One thing to remember: all ODBC drivers are not created equal.. I have heard some of the third party drivers offer more performance/less frustration than the Q+E/INet combo.. Good Luck! Tim Tow, CPA tntow@ingr.com 72773.1615@compuserve.com Compuserve Excel Forum "MVP" Contributing Author, "Excel Professional Techniques" by Que Books Contributing Author, "Making Microsoft Office Work" by Osborne/McGraw-Hill