The following new message has been posted on Phorm Support Forum at <http://www.phorm.com/support/>. *************************************************************************** MESSAGE: (#2626) Re: Check box question <http://www.phorm.com/support/?rev=2626> AUTHOR: Rich DATE: May 3, 2003 at 12:24 a.m. EST Reply To: (#2625) Author: Date: Patrick, Thanks again for detailed response. I changed the query to what you suggested and when I ran debug72 the result was: select Piece, EstHrs, Service, Turnaround, DocType, FileType, Platform, Pages from newproj where (File1 = '' OR File1 = '' OR File1 = '') AND ProjNum ='100231' Unfortunately, I am not getting any file names with this query, so I really couldn't run it thru the MySQL admin. The contents of File1 in the dbase is NOT a unique file. On my ack page, I would like the user to see below and that would be the separate sections: (File equals Piece). Thanks again ... Rich File 1: file1.doc Service: Editing Turnaround: Long File Type: Word Platform: PC Doc Type: Article Pages: 3 File Est: 5 File 2: file2.doc Service: Proofreading Turnaround: 24-Hour File Type: Word Platform: PC Doc Type: Advertisement Pages: 1 File Est: 3 File 3: file3.doc Service: Editing Turnaround: 2-Day File Type: Word Platform: PC Doc Type: Article Pages: 10 File Est: 15 *************************************************************************** This is an automatically-generated notice. If you'd like to be removed from the mailing list, please visit Phorm Support Forum at <http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If you wish to respond to this message, please post your response directly to the board. Thank you! ------------------------------------------------- You are receiving this message because you are subscribed to the Phorm mailing list. To send messages to the mailing list, simply send email to phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe from the list by sending email to phorm-request@xxxxxxxxxxxxx with 'unsubscribe' in the SUBJECT field.