>Lookups can be handled a variety of ways. One way is to grab rows and add elements to a combobox. As you might have already guessed, this is not something that you need DataClas for. That said, dataclas does provide a way to pass a query through to SQL Server. Once you have the ADO recordset, it then becomes a UI-specific issue as to how to deal with lookups...
>
>With respect to grids, I assume you are talking about VFP grids. Since we don't deal with VFP cursors, VFP cursors are not handled. However, OLE-DB grids do work. If you have not worked with this ActiveX control, you owe it to yourself to take an hour and play with it. It will not take you long to miss the quirks -bad ones at that - of the VFP grid.
>
>For any additional product ?'s - please email me personally with your ?'s. I will be happy to answer any ?'s you have....
>
>
>Best regards,
>
>< JVP >
Pardon me if I try to wrap everything up into little boxes. I would like a 'middle tier' (whatever that means anymore) to be something like dataclas and be able to funnel all data through it for whatever purpose I need data (including lookup). Is this something you are going to add to the product or is there a straight forward way to do it using existing code? I remember your talking about that ole-db grid at a Devcon in the past but I haven't used it. I will take a look at it.