Hello Richard, I think its not a good idea to access the global by yourself.
Use a parent and a child table without defining a relationship. Use a Property of type ParentClass in the ChildClass (indexed)! You have to handcode the relationship: in %OnDelete (or DELETE trigger) of the parent delete the children. Define some indices on the childtable and everythink works fine. If you don't want to use joins in your querys, you can use the -> Synatx to acces the parent: SELECT Value from ChildTable where Parent->XYZ = "something" HTH ^Florian
