Hi,

I'm new at creating an update query and not sure if that is even what I need to do. One of our departments has a database that includes fund numbers for each og their accounts. Those numbers are changing, and the database already has several entries since the beginning of the year. The main table is linked to mutiple tables and forms. They would like all the fund numbers to be changed. The fund names will remain the same. I made a beginners attempt at an update query by adding a new column to the main table called "Budget_Line_Number_New" and thought we could enter all the new numbers there, then update using that column. I get a message about key violations, lock violations, and rule violations. I don't have any idea how to figure that out. Can someone lead me in the right direction?

Thank you

They want to change the Fund Numbers already used? wouldn't that make any type of history obsolete? OR, do they want to now use different type of fund numbers? perhaps they used ones last year that had something like 11-##### and now they want to use 12-#### ?

Yes, they will be replacing all the entries for this year. They will be replacing the first 4 set of numbers, and the rest of the number will remain the same.

so they dont want to change the existing records only the new records ??

We can change all the records. There is no need for keeping the old records with the old numbers.

something doesn't sound quite right to me, but it is your data and your business.

I am reluctant to provide an answer unfortunately as I do not grasp the overall concept of your design.

Others will be joining in and perhaps one of them will understand better.

Bob,

Thank you so much for trying to help me with this. I was able to go in and remove the joins in the relationship table, do a find and replace in all the affected tables, then put the joins back in place. This worked for what they needed.

Thanks again.