Re: Heirachal recordset

Hi,

If you are not going to use SHAPE, then you cannot build hierarchical
recordset. All you could do is to open three different recordsets and if you
need to establish some sort of relations, then you need to use Find and
Filter of the recordset to get the records based on some condition. For
example, if you need to get list of Orders for the customer, then you could
filter recordset of orders based on customer's id

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Jlaz" <brenjoe3@xxxxxxx> wrote in message
news:OXHmgaDSFHA.3664@xxxxxxxxxxxxxxxxxxxxxxx
> Can anyone provide me some examples of using a Heirchal recordset such as
> Customers - Orders - Order Details in the Northwind database without
> employing the use of the Shape construct. Any help would be much
> appreciated. Thanks
>


.

Relevant Pages

  • RE: How do I build a customer search?
    ... The code I posted will make the record from the form's recordset the current ... Dave Hargis, Microsoft Access MVP ... "Dustin" wrote: ... This will help our people know what our customer has and also I would like ...
    (microsoft.public.access.formscoding)
  • RE: Search facility query
    ... Set rstClone = Me.RecordsetClone ... MsgBox "No Matching Customer Found" ... The name of the table or query that is the record source for the main form. ... Are these field in a recordset or controls on a form? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Change Control Source
    ... recordset in code for the purposes of building the string. ... base your report on a query that pulls the appropriate customers, ... customer ID ...
    (microsoft.public.access.reports)
  • RE: How do I build a customer search?
    ... "Klatuu" wrote: ... If there are data you want to show that are not in the form's recordset, ... Dave Hargis, Microsoft Access MVP ... This will help our people know what our customer has and also I would like ...
    (microsoft.public.access.formscoding)
  • Re: > 100 is causing strange results
    ... result is a date, so you're trying to compare the number 100 to a date, a ... So, to simplify the output, I have the customer id, ... > appear in the resulting recordset even f the variable input is 50 days. ... > the records after the user input date, ...
    (microsoft.public.access.queries)