Remove loop or not

[system]

Please, look here or here or here…

120×120 10.4 KB

We have a situation in our universe that is being identified as a loop but it’s really just a case where part of the foreign key resides in one table and part resides in the other. Some strange things are happening in the generated SQL and I was wondering if a context might help but I’m not sure it’s intended for something like this. I have attached a piece of the universe diagram but to sum it up: We determine what “service” a patient had by looking at a combination of the facility they visit…

120×120 10.4 KB

I know, I know I searched I promise, but I am having problem with the terminology of trying to search based on my question. Three tables A, B, and C. I need to create objects based on table C dependent on 4 values from table A and 1 from table B. Problem is, table A and B are joined and need to be, thus I have a loop. I am familiar with context and alias but not sure they will work for this situation. A context would define the correct path, but I really need both paths A-> C and B-> C defined…

etc.

In short, a loop might be necessary to get valid data, especially in highly normalized databases.

---

Andreas (BOB member since 2002-06-20)