For the first time I need to create a parameterized view utilizing > 2 tables and am not succeeding. (I'm using the view designer but have also tried to create the view from the command line without success.)

I need to create a parameterized view on a parent table "Group". Additionally I need the view to include one field each from three other tables. (There is only a single child record in each.) When I try to save the my view I get a message, "SQL: Column 'GROUPKEY' is not found.". The message() function returns "Variable 'GROUPKEY' is not found.".

I'm sure I'm overlooking something rather simple. The view designer's SQL statement follows.

Help anyone?? Thanks



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