I have a no. of fields on a form that I want to validate and prevent saving of the form until these are validated. Sort of things would be Rep, Area, County, Country, Dept etc. These could all be on the one form and are on the one Lookup table, referenced by a Lookup type key.

I have a Business Object set up with these Lookup lists and know I can check the Business Object...and that will work fine.

However , what normally tends to happen, is that a user is entering the details, realises say that there is an invlaid Dept. Then either that use, or perhaps a supervisor on another screen,  will 'add' in the Dept so the Lookup table, so it  is now up to date.

But, back to the user, who does not want to leave the exisitng form because they may have spent the last 5 mins entering data, has the old business object wihout the new dept.

Is it necessary , in these situations, to interrogate the database , or can the business object be 'refreshed' without leaving the form, so that any recent additions to the lookup table will be reflected in the 'Lookup' business object