Thank you sir!
I must have missed this post along the way.
Nope you replied to it 
Too much Tequila me thinks 
Constantly! Sometimes clicking off the field and then back into it works and other times I have to click into one of the other tabs and back for it to work.
I tried to duplicate this the other day and could not.
Can you give an example?
I mean, here it goes to PartNum, then PartDescription.
It does it in some places in classic too. I I drop down the list first, it works fine. If I donât, then it takes whatever the first one is, and then no matter what letter you type just moves the cursor over once. Itâs really annoying.
I see.
I figured something like that, but for the life of me I could not think of an example where the short one appears in the sequence after the long one.
Yeah, why canât it just filter the list rather than auto-complete?
Well, I mean I want auto-complete but also the filter.
I want all the things.
But thatâs got to be pretty rare, right? Where the longer one comes first?
Who on earth comes up with a long field name and THEN another field just like it thatâs shorter?
An evil genius, thatâs who lol.
If it would just sort alphabetically that would also solve the problem. Who cares what order the columns were added to the table??
I mean, usually the important ones are at the top.
Now why JobNum is like the 20th field in JobHead, that I will never understand.
I had no idea that was there!
Why hide that in the overflow menu?
Just to make you ask! Gotta have those easy wins!!
Easy win for Epicor: move the button where we can see it!
Youâre gonna have to put that in as an Idea.
Even Epicor support did not know that was there - I had put in a ticket about this issue.
Did you see it in smart client? No one uses it apparently, so it is not in the main panel.
As someone who by the grace of Codd has forged the bulk of their software experience on database design, database administration, database etc.
The answer to this and other database questions is programmers. Programmers wrote this database.