R
Robin S.
I have a query (qryProCatJoinDetails) with this format:
ProductID CategoryID Specification Prefix Value Suffix
24505 5 Voltage (null) 120 V
24505 5 Current (null) 8 A
24505 5 Blade Size (null) 10
Inches
BACKGROUND: This query is based on a join table - tblProCatJoin (holds
the "value" field) - which is based on three normalized tables -
tblProducts, tblCategories, tblSpecs. I use the query as a record
source for a continuous subform with which users enter the "value"
field for each specification of each product.
THE QUESTION: I need to concatenate these records into a table
(tblProducts) the - record will be there already
ProductID Specifications(memo)
24505 Voltage: 120V <p> Current: 8A <p> Blade Size: 10 Inches
Basically I'm building a description using HTML formatting for a web
shopping cart database. Depending on the category, each product can
have between one and perhaps 30 specifications, each category is
different.
Should I use an update query? I'm not even sure an update query would
do this. I would ideally like to loop through the continuous subform
and concatenate each instance of the continuous form and create the
description from there (seems quick and kinda dirty).
Thanks for any thoughts.
Regards,
Robin
ProductID CategoryID Specification Prefix Value Suffix
24505 5 Voltage (null) 120 V
24505 5 Current (null) 8 A
24505 5 Blade Size (null) 10
Inches
BACKGROUND: This query is based on a join table - tblProCatJoin (holds
the "value" field) - which is based on three normalized tables -
tblProducts, tblCategories, tblSpecs. I use the query as a record
source for a continuous subform with which users enter the "value"
field for each specification of each product.
THE QUESTION: I need to concatenate these records into a table
(tblProducts) the - record will be there already
ProductID Specifications(memo)
24505 Voltage: 120V <p> Current: 8A <p> Blade Size: 10 Inches
Basically I'm building a description using HTML formatting for a web
shopping cart database. Depending on the category, each product can
have between one and perhaps 30 specifications, each category is
different.
Should I use an update query? I'm not even sure an update query would
do this. I would ideally like to loop through the continuous subform
and concatenate each instance of the continuous form and create the
description from there (seems quick and kinda dirty).
Thanks for any thoughts.
Regards,
Robin