Regarding Data modeling

[#1]

Hai,

This is regarding data modeling in QlikView. I found few difficulties in linking Orders and invoicing tables. I'm getting the loosely coupled tables.

I have attached the application. Also, please refer the Links.xls which I'm using.

Please suggest me the best way of doing data modeling and how to avoid the synthetic keys and loosely coupled.

Thanks in advance..

[#2]

Hello,

I think the best way is to delete the line

SDOCID & PARTYID AS SOLINK,

in the tab "Invoice".

The data is given about the link to tthe tables SORDDETAIL and SINVDETAIL, I think.

Regards