I need help in seeing what is wrong with my checklist database

[cdell7up]

I downloaded an example file from "Megood", and used it's structure to make this database. I am having problems with the append query part. I can get it to append to the first record, but not the next. Can anyone figure out what I have done wrong?

Here is my db.ChecklistContractingDatabase.zip

[June7]

Because QuesNum field in AnswTbl is set as primary key and Indexed (No Duplicates).

[cdell7up]

Any suggestions on what can make it work? This is my first database in years, and I am behind the game somewhat.

[June7]

Don't set the field as primary key and then allow duplicates.

If you want a pk in this table, add an autonumber field.

[cdell7up]

How do I go about removing all the records in my database without messing anything up. I want to start the database with no records, is there some kind of query i run?

[June7]

Either go to each table and manually select and delete records or run a DELETE sql action on each table:

DELETE FROM tablename;

Use the query designer to build.

If you have established relationships with Enforce Relational Integrity and Cascade Delete selected, delete the parent record and all children will also be removed.