Bettina Posted March 2, 2004 Posted March 2, 2004 I created a value list in my secondary file using values from a field. This field ("ID tag") gathers info from another file (Master file). I have 143 records so far, which isn't much considering what I plan to enter in the future. As soon as I created the value list, I noticed that everything slowed down. Response time during data entry slowed greatly, etc... As soon as I removed the value list, it was back to normal. Does this have to do with the length of the value list or the fact that the info is coming from another file? I should probably also mention that my ID Tag (which we've discussed at length in the relationship forum) brings in information with it (i.e. First, Middle and Last Name as well as a few other things). I also have a few other value lists set up through fields. Would that add to it? Any ideas? Thanks. Bettina
CobaltSky Posted March 2, 2004 Posted March 2, 2004 Hello Bettina, Yes, value lists can become inefficient whewn large numbers of values are involved - and especially so over busy network connections (in hosted solutions). Quite apart from this, the merits of a value list as an interface device begin to diminish once the list becomes long (eg longer than a dozen or two items) because the business of scanning the list in search of that elusive entry becomes tedious - even for users who know about type-ahead techniques with drop-down lists. If, as you say, the list is already 143 items long and is destined to grow, I suggest that you consider other alternatives. One of the simplest of alternatives is to establish a filter for the value list, so that users firts select a range or category, then view a conditional value list of the items which relate only to the first selection. This or other such interace devices may be appropriate depending on the nature of your solution and the ergonomics of its use.
Bettina Posted March 3, 2004 Author Posted March 3, 2004 Thank you, Ray. I guess I'm out of the value list business now! I will follow your suggestions. I greatly appreciate it! Bettina
Recommended Posts
This topic is 7571 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now