I have an append query adding new records from a "temporary table" to another "Main" table. Upon closing the form, I deleted all the records from the temporary table. This seemed to work fine until we have more than one user in the database. How can I "check" to see if the MemberID already exists in the Main table and only add the NEW records?
Thanks, Doreen Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/