mapping several values

[#1]

Hello. I hope someone can help me. I've list of product codes and corresponding account numbers, account names and revenue groups. It would be easy to make a mapping table if there was only one value for the one product code. But, I have also 4 different cost center and there can be differences in accounts between cost centers. Here is an example for one product code:

Cost center	Product code	Account number	Account Name	Revenue Group
A	1000	3200	Waters	Food
B	1000	3200	Waters	Food
C	1000	4000	Entrance fees	Other
D	1000	4000	Entrance fees	Other

I have almost 400 products listed. Problem is that I don't know how to make mappings because of variation. The result what I want is that when I select cost center it willl show correct account information for products. Perhaps this is an easy one, I just don't get it.

Please ask if you need further information of the problem. Thanks in advance.

[tresesco]

Probably you are talking about optimization(else the table itself would give information what you want). To optimize you have to have multiple tables. For example, one master table say, 'AccountMasterTable' (with fields - Ac Number, Ac Name, Revenue Group ), and one trasaction table.

Hope this helps.

Regards,

tresesco