Ms access transform data to field name

Good afternoon, In ms access, I created a form with a combo box that lists all products, a subformat (datasheet) that lists all the companies that sell this product. (data)

I want the company (data) names to become (in the data subtest) the corresponding field names in the data table, so I can have other data for that company in that column.

Just like you compare phones with phone name (title field name) and its features,

plz thanks

+2


source to share


1 answer


Do you mean a crosstab query? The subform control will accept the request as its source object.



+2


source







All Articles