table join; want to see descriptive info with the relationship, not just the ID #

[crobaseball]

I have a query which is creating a joined table. The parent is a group category, the child table lists the individual items in it. I'm using an autonumber in the parent as the relationship field, connecting the tables. But I'd really like to be able to see the descriptive information for the group to make sure I'm linking the item information to the correct group. As you can see below, the 1st column is the relationship field.





And what I'd like to see is the Supplier and Series information. Is there some way to "see" this to make sure I have the correct SeriesID in the above table?



Thanks!

[Xipooo]

What is the SQL of your query? Open the query in design view, then right click and select "SQL View". Copy and paste that text here.

[crobaseball]

SELECT Lines.SeriesConnectedToLines, Lines.FlatTrimOther, Lines.ShapeCode, Lines.Size, Lines.Descript, Lines.Price, Lines.Freight, [Price]+[Freight] AS Landed, [Landed]*1.75 AS [DLR A], Round([Landed]*1.5,2) AS [DLR B],
[List]*0.6 AS [WHL A],
[List]*0.65 AS [WHL B],
[List]*0.75 AS Retail, Int(100*[DLR A]+0.5)/50 AS List
FROM [Group] INNER JOIN Lines ON Group.SeriesID = Lines.[SeriesConnectedToLines]
WHERE (((Group.Series)="Amber Valley") AND ((Lines.FlatTrimOther)="Trim"));

[Xipooo]

You just need to include the fields of the Group table that you want to show.

SELECT Group.Supplier, Group.Series, Lines.SeriesConnectedToLines, Lines.FlatTrimOther, Lines.ShapeCode, Lines.Size, Lines.Descript, Lines.Price, Lines.Freight, [Price]+[Freight] AS Landed, [Landed]*1.75 AS [DLR A], Round([Landed]*1.5,2) AS [DLR B], 

[List]*0.6 AS [WHL A], 

[List]*0.65 AS [WHL B], 

[List]*0.75 AS Retail, Int(100*[DLR A]+0.5)/50 AS List
FROM [Group] INNER JOIN Lines ON Group.SeriesID = Lines.[SeriesConnectedToLines]
WHERE (((Group.Series)="Amber Valley") AND ((Lines.FlatTrimOther)="Trim"));

[crobaseball]

You just need to include the fields of the Group table that you want to show.

SELECT Group.Supplier, Group.Series, Lines.SeriesConnectedToLines, Lines.FlatTrimOther, Lines.ShapeCode, Lines.Size, Lines.Descript, Lines.Price, Lines.Freight, [Price]+[Freight] AS Landed, [Landed]*1.75 AS [DLR A], Round([Landed]*1.5,2) AS [DLR B], 

[List]*0.6 AS [WHL A], 

[List]*0.65 AS [WHL B], 

[List]*0.75 AS Retail, Int(100*[DLR A]+0.5)/50 AS List
FROM [Group] INNER JOIN Lines ON Group.SeriesID = Lines.[SeriesConnectedToLines]
WHERE (((Group.Series)="Amber Valley") AND ((Lines.FlatTrimOther)="Trim"));

I wasn't thinking so much about the query as the actual table. I'm populating the data for the first time. Going forward I can use a form with the fields which you mentioned, though I suppose I can just include that information at the beginning, then delete the field once the database is established. That makes the most sense . . .

[Xipooo]

Why are you making a table at all if you can just use a query?