Hi All i need help with the following;
i am putting together two source systems thorugh the following logic.
i aim to derive a unique customer price for each timecode connected a relative artno which in turn is connected to a project number, with a specific customer attached to that project.
Table 1: PriceList - (Unique Customer Table that is linked to individual pricing scheme through use of an article number) - DB1
Table 2 links to the transactional table. (see db model pic attached for logic description)
| CustomerNr | artnr | pris(price) |
|---|
| 1 | 5010 | 20 |
| 1 | 4000 | 30 |
| 2 | 5010 | 40 |
Table 2: TimeCode - Table that connects to the transactional table and tells it which artno is been used in the project. - DB2
| TimeCodeId | tidkod | artno |
|---|
| 20 | consulting | 5010 |
| 35 | running | 4000 |
| 40 | snoozing | 3000 |
any modelling tips on how to create this relationship without running into circualr refernce and recieving the right price to the right project project number?
//best
Bradley
