Thanks for the quick replies. Poppa Smurf, the database is only a back-end...just Jet...no Access. Is that what you were asking? George, I always use autonumbering for the primary key, even on associative tables where the record just consists of foreign keys from other tables.