The following new message has been posted on Phorm Support Forum at <http://www.phorm.com/support/>. *************************************************************************** MESSAGE: (#2628) Re: Check box question <http://www.phorm.com/support/?rev=2628> AUTHOR: Patrick O'Hara DATE: May 3, 2003 at 12:40 a.m. EST Reply To: (#2626) Re: Check box question Author: Rich Date: May 3, 2003 at 12:24 a.m. EST Hi Rich, The bit of code that I gave you earlier, may not be needed in this, if I understand what you are doing. Go back to OR'ing the 8 files in the MySQL statement and ditch the code I gave you. I assume that although not unique, the combination of file name and project number is unique. Therefore, you should get back one record from the database for each of the three files you are using. (You can use the validation rules to restrict the selection to three files.) Therefore, you should be able to pull the records from DBFetch without to much hassels, just put... {{PHORM_DBFRSLT[0][Piece]}} {{PHORM_DBFRSLT[0][foo]}} {{PHORM_DBFRSLT[0][bar]}} {{PHORM_DBFRSLT[1][Piece]}} {{PHORM_DBFRSLT[1][foo]}} {{PHORM_DBFRSLT[1][bar]}} {{PHORM_DBFRSLT[2][Piece]}} {{PHORM_DBFRSLT[2][foo]}} {{PHORM_DBFRSLT[2][bar]}} This is basically what you were doing before, but for some reason I got the impression that what you were doing was more complex... maybe it is... :) Hope this solves your problem Patrick O'Hara WhitsundayIT QLD, Australia patrick@xxxxxxxxxxxxxxxx www.whitsundayit.com *************************************************************************** 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.