Cindy,

I do keep the data fairly normalized, I actually go a step further and regularly output a non normalized file directly to his hard drive because I don't want him anywhere near the live data.

Just trying to make a humorous point :-)

Bob

>Make him a view of the data, with all the lookup fields "looked up" and let hiim query the view.

>Explain that there are serious problems with not normalizing the data store, but you can normalize the data and provide him with something that is easy for him to query at the same time.