We have a series of nested relationships such as:
global_sec_users_to_sec_company.sec_company_to_sec_groups.sec_groups_to_sec_permissions
All works well like that with just one global as the left hand of the starting relation.
However we need to add a global to the left hand of the last relation too, and as soon as we do the relation fails to show up in the set relations dialog box so it cant be selected!
We have worked around this by creating the relation (for a tab form BTW) without the global and then changing the relation to use the global. This works well enough so its really a problem with the relation display when setting the relationship in properties.
Hope that makes sense. I have not tried this with other test data as awe are pretty tied up right now, and I don’t have a sample but it should be simple to replicate.