I approch this problem with a local view and the "nodataonload" property set to .t. in that way your view becomes you temp table.
Just an idea.
>Hi
>
>In my form , I use Dataenvironment , where i have 4 tables .
>I use buffer .
>
>I have a grid , and i whish use a temporary table , and only at the end save in main table .
>I want use a temporary table , because the main table have thousands of records , and a temporary table only have perphaps 10 records .
>
>So on load the form :
>
>Select LinhaFac && main table
>COPY STRUCTURE TO TmpLinFac && temporary table
>USE TmpLinFac IN 0 EXCLUSIVE
>Select TmpLinFac
>
>This don´t work .When i select TmpLinFac , i think that other table is select .
>Can you help me ?
>
>Thanks
B.D.H.