----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: BusyWizy Message 2 in Discussion there is no readymade method to do this. you will have to loop thru the rows, get all the id values, and the issue an appropriate select query. if the parent table has a small number of records, then u can loop thru all the rows, get the id values in a comma seperated string variable, and then issue a select query using the IN predicate. Otherwise, take an individual id, select the records for that id and keep appending it to a common datatable. hope that helps, nauzad kapadia [mvp] ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
