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|
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.
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.