>Hello gang,
>I'm trying to create a view using a sub-select, whilst VFP allows me to create it in code from the command window, it throws the error "SQL to complex" if I try to modify it in the database designer, all I'm trying to do is select records from a lookup table that are not in another based on a common field, this is how I've tried to do it
>
>Select * ;
>from elemtype ;
>where elemtype.claim_elem_code not in ;
>(Select elem_code from elements where elements.clm_ref = ?thisform.clm_ref)
>
>the actual code works fine, is there an easier / better way to do this??

Stick with maintaining this SQL in a PRG file. The View Designer can not handle this. Or download Erik Moore's EVIEW tool.