Ok, I'm still working through my process and I found that I'm processing my last record first before my loop which is not what I want. I need to start with the first record process the steps then move to the next record and so on until all records have been processed in sequence.
The attached image shows that the last record was processed properly, but just in the wrong order.