CREATE VIEW myView AS ; SELECT Group.groupkey, Group.suffix, Groupname.groupname,; Groupnum.groupnum, Notedata.textnote; FROM mhngroup!groupname ; LEFT OUTER JOIN mhngroup!group ON Groupname.namekey = Group.namekey ; LEFT OUTER JOIN mhngroup!groupnum ON Groupnum.numkey = Group.numkey ; LEFT OUTER JOIN mhngroup!notedata ON Notedata.groupkeyid = Group.groupkey ; WHERE Group.groupkey == ?thisform.CurrentGroupKey; AND Group.suffix == ?thisform.CurrentGroupSuffix