C
Chris Strug
Hi,
I have an unbound form in an ADP on which for a variety of reasons beyond my
control I am unable to use subforms.
My data comprises two tables, a job table with a many to one join to an
address table. I.e. each job can have 0 --- many addresses associated with
it...
I can happily use static ADO recordsets and stored procedures to view and
update my records, however I've just found out about shaped / heirarcheral
recordsets and these would be appear to be a good solution for my needs
rather than using two recordsets or lookups for the linked addresses.
I have been able to create a shaped recordset that opens these tables
grouped as they should and it does appear very useful.
My question:
I understand that in a shaped recordset, the linked table's rows are
expressed as an additional field in the recordset named "chapter1", hence,
rst!chapter!address_field returns the first "address_field" of the current
recordset.
My question is, how do I access the methods and properties of this linked
recordset - how do I move about, perform a seek, perform a recordcount, etc.
How would I (for example) move the last record of this "child" recordset...
Forgive my ignorance if this is a silly question but I can't seem to fathom
it.
I hope this makes at least some sense.
Any and all advice is gratefully received.
Kind thanks
Chris.
I have an unbound form in an ADP on which for a variety of reasons beyond my
control I am unable to use subforms.
My data comprises two tables, a job table with a many to one join to an
address table. I.e. each job can have 0 --- many addresses associated with
it...
I can happily use static ADO recordsets and stored procedures to view and
update my records, however I've just found out about shaped / heirarcheral
recordsets and these would be appear to be a good solution for my needs
rather than using two recordsets or lookups for the linked addresses.
I have been able to create a shaped recordset that opens these tables
grouped as they should and it does appear very useful.
My question:
I understand that in a shaped recordset, the linked table's rows are
expressed as an additional field in the recordset named "chapter1", hence,
rst!chapter!address_field returns the first "address_field" of the current
recordset.
My question is, how do I access the methods and properties of this linked
recordset - how do I move about, perform a seek, perform a recordcount, etc.
How would I (for example) move the last record of this "child" recordset...
Forgive my ignorance if this is a silly question but I can't seem to fathom
it.
I hope this makes at least some sense.
Any and all advice is gratefully received.
Kind thanks
Chris.