Harry,

Are you saying that when you USE or REQUERY the view you get no records?
If so, is there any chance at all that there are 2 different CONTACT databases/tables at play?

good luck


>between
>CREATE SQL VIEW CQRY AS SELECT * FROM CONTACT!CONTACTS WHERE TOWN='NEWPORT'
>which returns no records from a given database
>
>and
>
>SELECT * FROM CONTACT!CONTACTS WHERE TOWN='NEWPORT' INTO DBF 'CQRY'
>
>which returns 106 matches from the same database?