Jump to content
Sign in to follow this  

Finding before Entering

Recommended Posts

I'm sure that this is something many of you have done many times, but for me it's a first so I'd appreciate some feedback/advice.

I want to script a Find before allowing users to creat a new record (to be sure that it's not a duplicate). What I have in mind is:

1. Create a button that adds a new contact.

2. Have this button perform a Find that checks for matches of first name, last name, partner's first name, partner's last name, and street address.

3. Display all possible matches in a layout that lets the user either choose one of the existing records (if it's the same person) or create a new one.

Does this seem like a good way to do what I need done? The previous database had tons of duplicates, so I need to go the extra mile to prevent them in the new one. However, it's gotta be simple and easy-to-use as well.

Thanks in advance for your responses.

Share this post

Link to post
Share on other sites

I've done this before, and your logic seems to be good. When the user enters the name, I would have FM copy the field first before performing the find. This way, the user doesn't have to retype the name if they decide to create a new record. If the user decides to create a new record, have FM Paste the name field. Of course, if the name field is split into multiple fields (first/last name), this won't work (although you could create a full name field and set the first/last names fields with a script).

Hope this was helpful.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.