Hi all,

I've been able to keep a field generated list in the order i want by using hints on this post, the thing is that when using the list in another table via a link, (or even in the same table)

the text doesn't auto complete, actually the feature turns off.

basically i'm set this way:

"JobTitle" field

"index"field(to setup the order)number from 01 to XX

"Calculatedindex" field(using

Remplace2 ( 10^index - 1 ; "9" ; " " )

(sorry french application version here)

The list is generated using JobTitle & CalculatedIndex, sorted by 2nd field.

Any idea?

Regards

Dom

Help > Editing objects on layouts > Selecting and working with objects on a layout > Setting up a field to auto-complete during data entry:

"Auto-complete is not supported in drop-down lists when the value list used is configured to use Also display values from second field, Show values only from second field, or Sort by second field."

Thanks for the reply,

So are you aware of a custom function or a way to keep the "dynamic" list in the order i want but still keep the autofill feature enabled?

I tried a calc field, of the 2 fields used, but they show the spaces in the list.

Maybe i could use the index number and the jobtitle in a calc,to have something like

01-Jobtitle1

02-Jobtitle2

but i'd want to hide the first 3 characters when the list opens, and autofill to work on the first letters (or even better part of a word)for auto filling

I don't think it's possible. Perhaps you should explore other possibilities, such as conditional value lists or selecting from a portal/list view.