Linked tables

[jbphoenix]

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

 

[GohDiamond]

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