Linking problem

[#1]

I have a data model of 6 tables, joined by a common primary key,

in this 6 tables, 3 tables have Status, another 2 table has category, 4 tables have process which are sepearted by using aliases for modelling purpose

now when i click on one of the status, the reflexes doesnt get effective in other table/chart, why is this happening,

can anybody tell????

pls share some inputs on this, am confused, wqhy the data is not getting associated.???

[#2]

Basically you have to think about the Outer join based on the data structure and you have to write join query or outer query whereever it's appicable and avoid the no of table present in the model with FILE_NO

[#3]

didnt get ur point...

can u pls elaborate y thr is need of outerjoin???/

[marksmunich]

try renaming the all the status, since all the status are with different names like co_status, qr_status and qs-status, f_status and others... trying renaming the fields, then it must work.