End user query about lookups

[rosalea]

I am doing data entry into a form that was created by someone else, and on the form is a lookup box that I can use to reference a table that contains names I need to use to create a more complex record in a different table.

When I type in a name, the lookup will only go to the first appearance of that last name in the Names table, and then I have to scroll through a dropdown box to find the next occurrence of that same last name.

Is there a standard way to find the next occurrence of the name, or does that depend on whether the developer created a way to do it? He provided no documentation.

Thanks

 

[Moniker]

Since the names are identical, it will only find the first one. You can use the arrow keys to scroll without having to use the mouse I suppose, but unless you have the same last name 50 times, it's not that big a deal. If it's that big a deal, then you need to assign unique IDs that are not based on names but instead on unique, non-repeating identifiers.

 

[bloomy555]

I am doing data entry into a form that was created by someone else, and on the form is a lookup box that I can use to reference a table that contains names I need to use to create a more complex record in a different table.

When I type in a name, the lookup will only go to the first appearance of that last name in the Names table, and then I have to scroll through a dropdown box to find the next occurrence of that same last name.

Is there a standard way to find the next occurrence of the name, or does that depend on whether the developer created a way to do it? He provided no documentation.

Thanks

I don't know if my answer is correct, since I didn't get your question well.

can't you try to resort the lastname column in the Names table, so when you found one the others will be just below it.