In the case where matching record isn't found in table Trial, you're apending blank record in table Banks -- which moves the record pointer to the appended record (which becomes the last record in the table). This means you're not processing any records past the record in Banks that didn't have a matching record in table Trial.