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?
