I've got a table that frequently has to be zapped and reloaded. That's by design... what the client wants is to download something from the mainframe every morning into a text file and then my program will read in that text file and overwrite the contents of a table with this new information. Since the table is remote I've been using a view to work with it. But none of the three fields in the table is unique.

And I think that's what's causing me a problem. I'll delete one record (in the command window) but when I true to delete the next one or the one after that I get an "update conflict". I think that's probably because the view has already used the key that it thinks is there (because it's required) to delete every record that had "A7" (or whatever) in that field.

I'm thinking my solution is going to have to be to devise a key field and then rewrite my append routine to append the text into the "real" fields and leave the key field alone.

What do you guys think?

Thanks in advance.

(ps -- John K., when you get around to taking that fifth, pass a bit of it this way :) ).