>>What would be the easiest way to add records from a view (Temporary table) to another view (permanent table). Both have the same fields.
>
>
>INSERT INTO dbf_name [(FieldName1 [, FieldName2, ...])]
>
> SELECT SELECTClauses [UNION UnionClause SELECT SELECTClauses ...]
>
Thx Gregory.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé