Recordset from recordset

[_pi]

i make a main sql query for on item.
in my dialog there are 2 datagrids which need a source.

both datagrids need only partial fields from the recordset.

is it possible to make something like sub recordsets ?

Code:

Copy      Help

sql.from("Select * from daten WHERE ID=" _pid)
ADO.Recordset pf_einzel
pf_db.QueryRs(sql pf_einzel)