Alastair, Thanks This works great but is there any way to space it out and get a heading. I have to use 6.5++ for now. R>choose vcustcont from #values for (CC_contact & CC_OfficeExt & CC_Mobile1 & CC_HomePhone) from CustContacts where custnub2 = .This_Custnub2 Thanks Steve
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Tuesday, November 04, 2008 6:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: One works - other will not Steve, Put the concatenated columns in brackets: choose vcustcont from #values for (CC_contact & CC_OfficeExt) from CustContacts where custnub2 = .This_Custnub2 Regards, Alastair. ----- Original Message ----- From: Steve Breen <mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Tuesday, November 04, 2008 10:29 AM Subject: [RBASE-L] - One works - other will not The 1st onr works 2nd will not. What did I do wrong ?? R>choose vcustcont from #values for CC_Id, from CustContacts where custnub2 = .This_Custnub2 R>choose vcustcont from #values for CC_contact & CC_OfficeExt from CustContacts where custnub2 = .This_Custnub2 Steve ________________________________ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.6/1765 - Release Date: 03/11/2008 16:59
