Parent, Child & Grandchild records...

[ltidquist]

I'm using CR9 Pro with a SQL database.

In my database I have a heirarchy of records like this:

Headquarters (HQ) - an HQ record can have linked EMP (Employee records) as well as linked BREW (brewery records). BREW records that are linked to HQ records can also have linked EMP records. The child records are linked to their respective parent by the parent record's ID number.

I need a list of the HQ's who have a particular payment activity as well as all of the EMP's for both the HQ's and linked BREW records.

Any suggestions?

Thanks.

 

[fisheromacse]

just off of the top of my head, i think you would need to add the HQ table,then the EMP table and join it to the HQ table. then add the BREW table and join it to the HQ table, then add the EMP table a 2nd time and join it to the BREW table.
in the select expert, specify the HQ payment activity you want to report on.
that should give you a good start at getting the correct data.

 

[ltidquist]

I should have gone on to say that I need a row for each record with their Name/Company/Address information to be exported for a mailing list.

I've thought of the above scenario but that won't quite work because of the need for one row per record.

 

[Madawc]

You want an HQ address, and maybe one or more EMP addresses and BREW addresses?

Group by the higher categories. Put the addresses in the relevant group header, suppressed as needed. (Right-click on a sectin to see the section suppression option.)

If that's not it, please explain what the problem is.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP