>There's a view called vValid. This view contains all the legit choices a user can make in any particular combobox. For example the view contains types of credit cards (visa, mastercard, etc) and states (MA, MD, OH, etc) and collection method (web, fax, e-mail, etc). Every one of these records in the view has a unique id. The unique id is stored in the vCustomer or vInvoice or vOrder table. Since this unique id is meaningless to the end user, I have to UDF to the vValid table for the description when building a sql command for reporting. So, I wonder if the UDF should be stored with the views in the view dbc or should the UDF go in the VFP table dbc? My guess would be in the view DBC since all processing is between the views.
>
>Thanks for your help, Erik. Sorry for being long-winded.
Are you saying you have several views, one filled with valid states, one filled with valid collections methods, etc?
Why are these aren't you just joing these tables in the main view?
Sorry for dodging the origina question, but I can't answer if I don't understand why you are using the UDFs.
Erik Moore
Clientelligence