>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.
Then you may want to post a new message when you get back and include a little more detail -- Key Field(s) in each table, how each table is related to the other, business rule you are trying to meet, etc.
Mark McCasland
Midlothian, TX USA