I was working with a view which links two tables, when ran it was not joining the correct records.
The linked field in the first table (staff) was called 'number' and as it is a reserved word seemed to be the cause.

BTW I deny responsibility for this debacle as the database was created before my time.

The thing is a Select on Staff.Number returned the record whose Recno equalled it.
Is this another way to reference Recno or has the reserved word usage just sent things haywire ?

I'll probably not read any comments on this for several weeks as I'm off to change all references to staff.number in this whole system !