I didn't really figure anything out. It didn't work on Tuesday, but it works on Wednesday. I have no idea why.

I did learn some things in the process,...

As I mentioned previously there are several more tables involved. If one of them is the "key" table in the database, that archives one would be it, so that's...

I don't have code for creating the database. As I indicated previously, I didn't create the thing, I just get stuck cleaning it up when the end user does...

It didn't occur to me to verify the datatypes were the same, good point. Unfortunately it didn't help this time as the datatype is int.

I didn't design the database,...

Thank you for the reply.

Bummer, I was hoping there was some sort of automatic background thing that was part of the database that wouldn't show unless you looked for it.