How to auto fill different rows in the same table

[Guest]

I know how to do an append query from one table to another, but can't figure
out how to do the same thing with just one table. How do you run a query and
auto fill different rows in the same table? A select query seems to need two
tables and although I can set up an append query and select different fields
in different rows to append data, I get key violations, etc.

Thanks,

 

[Guest]

If you are using an autonumber for key field then just append those fields
you need but not the key field.