Jump to content
  • 0

AutoComplete Feature - 2 Users with Same Name



I have an issue trying to use the autocomplete feature on one of my fields in my sub form.

I have a Client_Table that is a table of customer information with a lot of records in it. Before, I would use autocomplete on Alias (first + last name) and that would fill the following cascading fields with contact/address information. However, I ran into a problem when two users have the same exact name. When there is 2 'John Doe's, only one of them shows up on the AutoComplete value list, and it does not populate any of the following cascading elements. 

It would be great if there was a separate value and display value for these autocomplete elements, but there is not. Therefore, I cannot use the ID field, as the users do not have this information, and I would much rather have them use names. Second, I can't change their Alias to be different because these fields are often used in PDFs of professional invoices and documents. I can't have 'John Doe 1' on one of these. 

Anyone have any ideas, or have found a workaround for something like this?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi kpcollier,

Usually contacts/customers info table contains an email which is unique.

If you already have one, or if it make sense for your contacts to have an email with your design, then this would be the object that uniquely refers to a specific person and unlike the ID, this is something that users know by heart. Try to fill cascading fields using this.

Does it make sense for your workflow?  If no, you may share the link to your test DataPage or some screenshots with us, maybe we can work something out.

Link to comment
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.

Answer this question...

×   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.

  • Create New...