Concatentation woes

[JohnLute]

I have a field:
tblPKCGPhysicalAttributes.Style

Style is a combo box that queries:
tblPKCGStyles.txtCodeID.CorrugatedStyles

txtCodeID is the bound column and it's values are saved in the Style field.

My report needs to display both txtCodeID and CorrugatedStyles.

I'm very confused by this and would greatly appreciate any guidance you
might have.

Thanks!

 

[Duane Hookom]

Can you add the table tblPKCGStyles to your report's record source and
include the field?

 

[JohnLute]

Thanks, Duane. tblPKCGStyles is an unrelated table. If I add to the query
then I'll have issues.

Do I need to make this table relational in order to have both txtCodeID and
CorrugatedStyles display on my report?

 

[Duane Hookom]

It's not clear what your tables are storing and what you want to display.

If you are using lookup fields in your tables, read
http://www.mvps.org/access/lookupfields.htm.

 

[Marshall Barton]

I have a field:
tblPKCGPhysicalAttributes.Style

Style is a combo box that queries:
tblPKCGStyles.txtCodeID.CorrugatedStyles

txtCodeID is the bound column and it's values are saved in the Style field.

My report needs to display both txtCodeID and CorrugatedStyles.

I'm very confused by this and would greatly appreciate any guidance you
might have.

Add the tblPKCGStyles table to the report's record sosurce
query. Set the join line between the two tables from
tblPKCGPhysicalAttributes.Style to tblPKCGStyles.CodeID.
Then you can add the CorrugatedStyles field to the query's
field list.

 

[JohnLute]

Thanks for everyone's input - lots of good info. I've got it worked out now!