I just completed a rather handy tutorial for Form Tools users.

It checks incoming form submissions to ensure that the incoming information hasn’t already been added in the database. This lets you ensure that multiple submissions don’t get registered with the same email address or username, for example. The actual criteria for uniqueness is entirely dependent on the form content.

http://docs.formtools.org/tutorials/checking_for_uniqueness/