AnsweredAssumed Answered

Trying to create records in another table

Question asked by Ben_B94 on Apr 12, 2016
Latest reply on Apr 12, 2016 by Mike_Mitchell

But it only creates 1 record.


go to layout (locations)

go to record/request [first]

set variable $listLocation ; get(total record count)

set variable $counter ; 1



      set variable $location ; Location::location_ id

      freeze window // not sure i'm using this right

      go to layout [Hire]  

      new record/request

      set field (Location_fk) ; $location

      go to original layout  // this will go back to the locations layout or no?

      set variable: $counter ; $counter + 1

      go to record/request [next;exit after last] // this doesn't seem to be moving to the next 1?

end loop if [ $counter > $listLocation ]


end loop


Basically trying to create a new record on a different layout for every location record I have. Thanks