LiveCode Forums.

Code: Select all

set the itemDel to tab

repeat with AU = 1 to the number of lines of order_id_name
put item 1 of line AU of order_id_name after new_variable

   repeat with track_id = 1 to the number of lines of order_id_tracking
            if item 1 of line track_id  of order_id_tracking is item 1 of line AU of order_id_name then
            put tab & item 1 of line track_id  of order_id_tracking & CR after new_variable
            
         else
           
            
         end if

Code: Select all

on mouseUp
   put fld "name" into tNames
   put fld "id" into tIds
   set itemdel to TAB
   
   ## Loop through all NAME pairs
   repeat for each line tLine in tNames
      put item 1 of tLine & TAB into tItem
      put lineoffset(tItem,tIds) into tOffset
      
      ## No match, modify this line if you want to add an empty ITEM 
      ## to the current NAME line or whatever you want to do in that case
      if tOffset = 0 then
         next repeat
      else
      
        ## repeat for each is READ only, so we just create a new list form the resulting data:
         put tLine & TAB & item 2 of line tOffset of tIds & CR after tNewList
      end if
   end repeat
   delete char -1 of tNewList
   put tNewList into fld 3
end mouseUp