>We're using views in a multi-user environment. We're finding that just loading the lookup views for a form can take a fair amount of time. But, yeah, otherwise, there would be no problem requerying the data when needed.

One thing that I have speced out a bit, but haven't coded yet or implemented is a Delayed Query Combobox...

the idea is that the combobox only retrieves the data it needs for the current value of the field. If the user drops it down, at that point in time, it would go out and query the full drop down list of data.

***********
Or.. for validation... do what you are doing, but, create a code lookup class of some kind... base the class on a form that has its own datasession. When the class starts, it will pull across the entire lookup table.

Now, when you need it, you just request the class to return the info you need.

BOb