Thanks Dylan, But I still cant figure it out how to fill the table B.
Each loop on Table A the zTmpQual gets something like: "('490008000'= $TableAColumn$)" So at the end of the guide I got a value form the last table A record. It results that Table B holds only record related to this last record. How to get all of related records? On 15 Kwi, 09:16, "Wheeler, Dylan" <[EMAIL PROTECTED]> wrote: > Second part is fairly easy. Create a display only hidden field, name it > whatever zTmpQual. Build your qualification with the AL guide loop into > that field. The Table B qualification will be EXTERNAL($zTmpQual$) > > Second thought on the first part, if the AL Guide is giving you the last > ID then make sure your adding it to a field and not overwriting. One way > to check is to pop up a note message on the beginning leg of each loop > with the ID. > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"