Reusing Lookup tables, multiple fields

[ww55d]

I'm fairly new to Framework, but have experience in other platforms.. The model I'm currently working on presents an interesting challenge i'm not sure how to approach..


Fact Table:    Events
Dimension Tables:    Codes, Entity

relationships:
events.cause_code = codes.code_id
events.department_code = codes.code_id
events.event_type_code = codes.code_id
...
...
events.division_entity = entity.entity_id
events.facility_entity = entity.entity_id

I'm going based on the Database / Relationship / Business Layer framework format..

Everything looks as it should when I'm bringing in fields from the entity and events table.. However when I'm faced with a prompt, it wants to bring back everything from the Codes.code_id table, without evaluating its relationship to Event.. is there a way to get it to force the join between Event and Codes or Event and Entity?

ps.. There are roughly 12 code lookups per event and 8 entity lookups.

example attached.

[bdbits]

Going to the lower right outside the screenshot, are those also going to the codes table? It looks like the cardinalities are reversed.

[ww55d]

Good eye.. Those go to two other tables.

One was indeed backwards.. event -- calendar

One is correct.. each event can have multiple persons involved..



Thanks

Going to the lower right outside the screenshot, are those also going to the codes table? It looks like the cardinalities are reversed.

[bdbits]

Glad I could guess right this time.  8)

Have a great day.