long VL

[musicarteca]

I need to use a value list in a portal, displaying the contact name, to enter the contact ID to establish a relationship between two tables. This VL might grow eventually to a fairly large number of records to be easily managed on a VL. What is the recommended procedure for this situation.

[Kent Searight]

Maybe consider a filtered portal in a popup window to allow the user to minimize the number of records that need to be perused at one time.

Edited March 26, 2006 by Guest

[LaRetta]

With vs. 8, you can also specify drop-down list and Auto-Complete. My Users adore this new feature and it has allowed me to uncomplicate my structure in several places.

UPDATE: If the number of selections grows past a hundred, I still filter as Kent suggests AND provide Auto-Complete on the filtered VLs. For instance, our Contacts are at 85,000. No way I would wait for FM to provide THAT drop-down without filtering...

Edited March 26, 2006 by Guest
Added Update