I have a value list taking values from a field (the PrimaryKey) in a table.
I also have the second field option checked with the field most users are looking for.
I also have the option checked to show only and sort by the second field.
All good, but the option for Auto Complete for the drop down list that uses this value list in the data inspector is disabled. I'm assuming this is because I'm sorting off of the second field. (the value list reference field is in a related table to the table that the layout is based on).
Is there any way to auto complete from the second field?