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/
 


Reply via email to