This is crazy after all these years I have done of detailed development, but I can't really understand the Global Join Manager.

I have three custom tables that I created.

TktSymptoms --> TktSteps --> TktStepData

Each is 1 to many from left to right and TktSymptoms is 1 to many from the Ticket table.

When I set up the parent (1) -> child(many) global joins as cascade delete the delete works fine, but they are not visible in the query builder (visible set to Always).  If I reverse the joins so that the parent is the many and the child is the 1, then they show up in the query builder, but the cascade delete does not work.

I have tried putting the joins both ways(hiding the deletes), but fear that this will cause performance issues.

Can anyone tell me what is wrong?

Steve