Hi,
I have a project table where I need to update a contact_id field (a foreign key to a contact table). This is easy with a dropdown list and a value list, but the problem is the contact table is in the thousands of records and therefore it's tedious to locate the one needed (specially when you only know a part of the name).
One solution could be to build up a value list entering a part of the name of the contact on a text field, which then would filter the records that contain this string. I've been strugling with this without success, because all I tried involved calculations that could not be indexed.
Anyone? I'd thank very much any help!
Llorenc