I may have left some info out. the 4th table I am trying to fill has 17 fields to fill from the other 3 tables. I was trying to fill them with the "REPLACE" command because the structure is set for uploading to a adabas database. I have not wrote the code to create that table just because of the business rules involved. Multiple joins or unions in SQL confuses me, especially this one.
I assume that is where you were going with updatable view and the requery().
If this is the best solution, I need a little help with the code. Thanks.
I have to go to a meeting. I will revisit this tomorrow morning.