Ok, here's my issue -

We need access to generate a unique number for RMA's. Then we take that RMA# and put it into our MRP system to finish the RMA process. I am trying to figure out a way to get the RMA# and some other data into our MRP without having to go to both applications.

Here is what I have so far - I have a linked table (Customer_Order) which is from our MRP application. I have a form that generates an RMA# and type. The RMA# needs to go into the OrderID field in the Customer_Order table. I tried using an append query to get the data from the RMA table into customer_order but I get key violations. I ran a query to see if duplicate data existed but none does. Any ideas how to set something like this up?

Thanks

Use the UPDATE query for records that already Exist when changing data in a FIELD in that existing record.
Use the APPEND query to add records that do not exist in the table.

Joe Jones record exists, I want to UPDATE/Change his existing Customer_Order.[OrderID] with a new RMA#, so, I use the UPDATE query.
Tom Thomas record doesn't exist, I want to add him and a group of others like him and their complete information to the Customer_Order table, so, I use the APPEND query.

I hope that helps,

Goh