test data restart

[MER]

after I make tables, reports, froms,
subreports/forms...............a whole little system,
can I delete all the records in my tables and start with
fresh real data?

just by deleting rows in the table?
or do I have to make COPIES of the tables with structure
and NODATA, delete the old names, and rename the tables
back to the original names from COPIES?

 

[PC Datasheet]

Yes, all you have to do is delete the data in some or all of your tables. You
may have to delete from the tables in a certain order depending on what
relatonships you have between the tables. Also, where you have Cascade Delete
enforced, deleting all records in the primary table will delete all records in
the related table. 99% of the time you hen want to compact. This will reset all
your autonumbers in empty tables back to 1.