Connecting tables and avoiding circular reference

Fri, 28 Sep 2012 21:47:02 GMT

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

topic Connecting tables and avoiding circular reference in QlikView

Connecting tables and avoiding circular reference