Horses IDN Name Gender 1 Silver Horse 2 Golden Mare 3 Silverado Horse Heritage IDN Mare Horse Child 1 2 1 3Your selct statement would be something like:
SELECT Horse.Idn AS SireID, Horse.Name AS SireName, Mare.Idn AS MareID, Mare.Name AS MareName, Child.IDN AS ChildID, Child.Name AS ChildName ; FROM Heritage ; JOIN Horses Horse ON Heritage.Horse = Horse.IDN ; JOIN Horses Mare ON Heritage.Mare = Mare.IDN ; JOIN Horses Chile ON Heritage.Child = Child.IDN ; INTO CURSOR Children