Displaying several recordsets with a single MSHFlexGrid object

[sagiv74]

Hi ,

I'd like to show several recordsets using a single MSHFlexGrid \ DataGrid .
Is it possible to change the recordset shown by one of those objects ?(every recordset is related to different table in my database).
If the answer is possitive - how should I do it?
Many thanks
Sagiv

[Iouri]

You can use MSFlexGrid to show several tables. If tableas are identical you can create a recordset using UNION, if they are different tabel you can use JOIN statement in your SQL. After creating a recordset use it as a recordsource for your msfg.

Iouri Boutchkine
[email protected]