Easy way to search?

[Saucepan]

hi,

ive got a database with a contacts table, and a notes table, which im putting together using emails. the idea is that when ever i get an email i download the mail to the database (by first exporting it as an excel file and then importing the info i want), keeping track of all my contact and all my notes.

now, the thing is, whenever i get an email from a person already in my database dont want to rewrite his/her info, nor duplicate it, i just want to stick in the new note. now i know how to find the person in my contacts table (matching email-adresses) but if im going to do this for every person in the contacts table, every single time im putting a new note, its going to take forever to just update a few contacts. is there any way to speed this up?

thanks

[Inky Phil]

I think we have this covered here

http://fmforums.com/forum/showtopic.php?tid/178750/post/214908/

[Saucepan]

we truly did... it was really a split problem...

[Lee Smith]

Hi Saucepan,

This sounds like you double posted.

we truly did... it was really a split problem...

If so, please do NOT double post in the Forum, it really isn't necessary as this is really only one list. If you have an additional thought or question on the other thread, you should just make a Reply to it.

Thanks

Lee