Steve, This is my interpetation of what you are trying to accomplish. This is based on the syntax of the latest version of 7.6. vtesttest1 is the variable containing the customer number selected by user. The syntax is listed in the ancillary document entitled: "All About The Choose Command" installed with R:BASE updates.
There are many other possibilities regarding how to restrict and narrow down the search for your users, for a particular customer. Regards, Ken choose vtesttest1 from #values for distinct + ( (LJS(CC_contact, 20)) + & (lJS(CC_OfficeExt, 5)) & (RJS(CC_Mobile1, 12)) + & (RJS(CC_HomePhone, 14)) ), custnub2 from CustContacts + where CC_ActiveStatus = 'Y' + ORDER BY CC_CallOrder TITLE 'Contact Office Ext Mobile# Home#' FORMATTED ----- Original Message ----- From: Steve Breen Date: Wednesday, November 12, 2008 9:37 pm Subject: [RBASE-L] - Union Select Question To: [email protected] (RBASE-L Mailing List) > I know I am not close. > > Any ideas or help would be appreciated. > > Clear var vTestTest1 > > Set var vTestTest1 = 'test test' > > choose vcustcont from #values for + > '.vTestTest1', 0 from custcontacts where count = 1 + > union all sel + > ( (LJS(CC_contact, 20)) + > & (lJS(CC_OfficeExt, 5)) & (RJS(CC_Mobile1, 12)) + > & (RJS(CC_HomePhone, 14)) ) from CustContacts + > where custnub2 = .This_Custnub2 and CC_ActiveStatus = 'Y' + > ORDER BY CC_CallOrder AT 2 1 TITLE 'Contact Office Ext > Mobile# Home#' > > > > Steve > > > > > > > >
