I've set up a 'LOOKUP Combo' which uses a SQL select clause to select records from a lookup table. The lookup table has different records in it , with one field which specifies a Type, e.g. Type = 'GROUP' is in all records which are classified a s a group, Type = 'REP' for all records which are classified as a Rep.

I want this Lookup to be global, with a parameter which specifies the type of lookup. I'v set this parameter up as a Property in the class (property is pctYPE) and my SQL select is as follows:

select description from look into cursor mycursor where look.type = pcType


I've saved this as a Class and thought that I could use this for any Lookup by just setting the property accordingly...... but message comes up saying property can only be used in method code !!

Anybody know any workarounds ?

Regards,

Gerard