>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 ...]
Gregory