How to construct dynamically a table field based on query criteria.

[dealwi8me]

Hello all,

I have a temporary table with Yes/No fields (F101,F102,F103,....etc).
In another table i have a field called ProductCode with values (101,102,103,....etc)
Is it possible to append(or update) the records of the temp table with criteria on "F" &ProductCode field? (For example if ProductCode=101 then F101 sets to yes)

Thank you in advance.

 

[dealwi8me]

This is how it goes...

Table tblCompany (Fields: CompanyID,....etc) keeps info about different companies and has 1-to-many releationship with table tblProducts (Fields: ProductID,CompanyID,ProductCode,....etc).
Table tblCompany also has 1-1 releationship with tempRegistry table (Fields: CompanyID,F101,F102,F103,.... etc)

What i want to do is get all the product codes for each company and check the proper checkboxes in tempRegistry.

 

[dealwi8me]

That's a temporary table i use for a report.

The report format must be like this: One column for the company name and one column for each F field. If one company owns one or more products with code=101 for example then the F101 must be checked on the report.