AnsweredAssumed Answered

Can I Auto-complete a Drop-Down list using a Calculated field?

Question asked by brian.curran on Jul 11, 2012
Latest reply on Jul 11, 2012 by brian.curran

Title

Can I Auto-complete a Drop-Down list using a Calculated field?

Post

I've been struggling with this for hours now and have ended up really confused after trying so many different combinations of relationships and value lists. I really would like to use a DropDown list rather than a Pop-Up as I prefer the auto-complete method of data entry.

In an 'Employees' table, I have:
__kpEmployeeID (Number) Indexed, Auto-enter Serial, Can't Modify Auto
NameFirst (Text)
NameLast (Text)
_cNameFull (Calculation) NameFirst & " " & NameLast

I've created a Value List called "Employees", which takes its values 'From Field' (top option):
Use values from first field:
Employees::__kpEmployeeID 

Also display values from second field:
Employees::_cNameFull

Show values only from second field is ticked.

In a 'KeyDetails' table, I have:
ReceivedBy (DropDown)
Values from "Employees"

Up to this point, everything seems to work fine. I can choose an Employee from the dropdown list by either typing, using the arrow buttons or by mouse selection.

What I would like to do next is to overlay the Employees::_cNameFull over the top of the KeyDetails::Receivedby field so that the name is displayed rather than the __kpEmployeeID

If anyone could advise me on the relationship required between these two tables and if there are any errors with the above, I would be very grateful...

Thanks
Brian. 

Outcomes