Thank you very much for helping me with this. I was able to solve the issue using an update statement.