I have defined a few tables and relationships, however, between some tables I am unable to create a relationship.
Say I have 2 tables D and U where U is defined as a child to D
Then I have 3 other tables C as a parent of S as a parent or T
and what I now need to do is define a relationship between D and T
I select the non-identifying relationship button, click on D and move the cursor over T, but all that happens is that T flashes, and I cannot choose it
I created another table A and made that a child of D
Does anyone know of reasons why I would not be able to link 2 tables which do not have a relationship currently, and where the new relationship would not cause any kind of relationship confict?
Customer support service by UserEcho