Because the Customer_Type is no longer available in the Customer Browse I altered the [Customer] section of the VMBROWSE. This worked great and gives me the ability to search by the Customer Type, however double clicking or using the Select and Close will return nothing to the Customer Maintenance window. Im not sure if I have a made an error somewhere?
[Customer]
version=40
table=CUSTOMER,CUSTOMER_SITE
title=Customers
key1=ID
sort=ID
order=1
where=CUSTOMER.ID=CUSTOMER_SITE.CUSTOMER_ID AND CUSTOMER.ACTIVE_FLAG='Y'
searchfirst=0
autorefresh=0
decode=BACKORDER_FLAG,Boolean,DUNNING_LETTERS,Boolean,TAX_EXEMPT,Boolean,TAX_ON_WHOLESALE,Boolean,CREDIT_LIMIT_CTL,CreditLimitCtl,CREDIT_STATUS,CreditStatus,FREIGHT_TERMS,FreightTerms,TERMS_DISC_TYPE,TermsType,TERMS_NET_TYPE,TermsType
autobrowse=0
cudfappid=VMCUSMNT
colA=CUSTOMER.ID,ID,1,1.50,5,0,
colB=CUSTOMER.NAME,Name,2,1.50,5,0,
colC=CUSTOMER.SALESREP_ID,Salesrep ID,3,1.50,5,0,
colD=CUSTOMER.USER_2,User 2,4,1.50,5,0,
colE=CUSTOMER_SITE.CUSTOMER_ID,Customer ID,5,1.50,5,0,
colF=CUSTOMER_SITE.CUSTOMER_TYPE,Customer Type,6,1.50,5,0,
