Avoiding two tables with same data

[Guest_imported]

I need to query information in an access table both by the field name and the data contained therein. The only way I have found to do this is to duplicate the data in two tables with the field names reversed. There must be a better way so that all of the data does not need to be input twice. Example:

Field names are Products available for sale and each record indicates a different commission for the sale based upon the contract the salesman has. This allows me to search for a commission based upon a contract.

A second table uses the contracts as the field names so that I can query to find commissions based upon a product.

I'm an experienced user but still a novice. Can anyone direct me to a source where I can find an answer. Will Pivot tables help at least for data entry?

Thanks

 

[BNPMike]

Try 'data analysis'. Write down your problem in English then underline all the entities and data items eg Salesman, Product, Commission and then write down how they relate to eacxh other eg A product has one/many commissions for each different salesman. A contract can cover one/many products. etc.

When you have got that clear you can create Access tables in a few moments. At the moment your data model looks wrong.