Linking a table to itself

rbuser

Hi,
I need to make a report whereby I list a group of assemblies ('parts'
table) and their details - size, price, etc. ('details' table). But for
each assembly I also want to list the parts within that assembly. These
part numbers are on the same table as the assemblies. There is a key
indicating what assmebly they are in, if any.

I can do this scuessfully for 1 sub level, but not for further
sublevels. The 2nd sublevel just will not display on the preview,
despite bing linked and organsied exactly as the first.

Heres how I am doing it:
I have linked together the parts and detials tables by table join (right
outer is the format that works).
Then I have created the exact same table join (creating PARTS2) for the
sub level and linked it to the first via the master detail relationship.
The data from parts2 is a subreport in the main:parts tab
This displays my data fine.

But when I do this again for the third table (PARTS3) (2nd sublevel), it
just wont display any of the data on the report. Again I have a created
subreport (PARTS3) within the PARTS2 subreport.
Note: The correct data IS however shown on the preview of the PARTS3
table in the data area. Im so close....

Any ideas please?

Thanks
Red

nicocizik

Hi Red,

This sounds like it should work from what you describe below. Be sure you
are ordering your Parts3 dataset on the linking field. Take a look at demos
71 - 73 if you get a chance and see if you can spot anything different that
you may have overlooked. All of these demos use a master dataset with
multiple details.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com