Display data from multiple tables 1

[JBaileys]

In the current schema, there is one master table with a colors sub-table and location sub table. Master has a 1 to many relationship with both colors and location.

There may be merit in creating two separate sql statements in what may be a subreport.

The goal is to display the master item with a list of all possible colors and then show a list of the items locations.

Thanks,

jb

 

[lbass]

You might want to use the Master and one table in the main report, and the other table in the subreport, linked to the main table on some ID field, and where the subreport is placed in a group section.

-LB

 

[synapsevampire]

It doesn't really make sense because generally a location table states a specific location and the color. All colors are not in every location are they?

Anyway, subreports are generally slow, consider posting your software version and the database/connectivity and the fields being joined on for more efficient solutions.

I would think that if you want to know locations, you would join the part to the location, and the location to the colors. Then if you really need all parts even if you don't have a location, add the location and color table in again in the same way and change the record selection to those where the isnull(color2.joinedfield)

Hard to say from the information provided so going with the subreport might suit your scope better.

-k