Hi Mark
>>
>>In Clipper we have the command
>>"set scopetop to " and "set scopebottom to"
>>This was to create a view off a portion of the database.
>>
>>Is something like this also possible in VFP

You mean like a parameterized view? See VFP Help on Create SQL View. And by database, do you mean a table?

I mean Table

when i use

thisform.datebox.value = dtoc(dDatum)
select datum, periode, &cID from jaar where jaar.datum = dDatum
browse

I see the table with 2 fields and 4 records

select temp
append from jaar
browse

I see 6 fields and 365 records

But i need a temp table with 4 records


Ben