Lars Ole Sørensen
Member
| Customer | Customer segment |
| Kjopernavn | Kundesegment |
| A&O SEAFOOD EXPORT AS | Export for further processing |
| ABS AS | Export for further processing |
| ANDREAS BJØRGE SEAFOOD AS | Clipfish |
| I am using the above lookup table to find the customer segment for each customer in the table "Fangstdata" |
| But each customer can have different customer segments based on the type of product the buy, in this case fish type |
| In the table below I have illustrated how this can look like, and fish type can have difference segment between different customers |
| I having problem to connect this to the table "fangstdata" so that I can get a report on total amount (belop) for each customer segment |
| I hope I was able to explain my problem well |
| Thanks for any help |
| Customer | Fish type There are around 30 fish types | Customer segment |
| Kjopernavn | Fiskeslag | Kundesegment |
| A&O SEAFOOD EXPORT AS | Cod | Clipfish |
| A&O SEAFOOD EXPORT AS | Shrimp | Shrimp |
| A&O SEAFOOD EXPORT AS | Haddoc | Filet |
| A&O SEAFOOD EXPORT AS | Other fish types | Export for further processing |
| ABS AS | Cod | Filet |
| ABS AS | Other fish types | Export for further processing |
| ANDREAS BJØRGE SEAFOOD AS | All | Clipfish |
| Here is the connection between the "kjopernavnDim" table and the "Fangsdata" table |
Kindly Regards
Lars Ole