calculated column that retrieves a value from another table based on related columns multiple tables

[Anonymous]

Hi,

I am facing a problem and spent couple of hours and still stuck on this. If you can help that would be great. I have 4 tables from which I need to calculate a field.

1) Main table (where I want this calculated column)

2) DRG - connected to main table by stay number

3) ELOS - connected with DRG with DRG number

4) Facility- connect with DRG with facility identifier

All relationships are many to many.  ELOS is identifiy with two things DRG and peer group which is in Facility table. 

I want to create a calculate column in Main table to get ELOS value from ELOS table for each row. 

[lbendlin]

ok, what have you tried and where are you stuck?  Have you considered using RELATED or RELATEDTABLE  (after fixing your table relationships to bring your data model into star/snowflake shape)?

[Anonymous]

It is solved. I had many to many relationship thats why related was not working. I changed the relationship of those two table and it worked. Thanks for replying.