I have a parent 'SITE' table with Global ID linked to a child 'INSPECTION' table with the GUID in a 1-to-many relationship.
Can I add another parent 'PATROL' table and point its Global ID at the child GUID also.
Creating another GUID in the child table for Patrol would probably accomplish this but thought as the inspection is either done at a site or during a patrol i'd reuse the field?
