J
jbphoenix
I have a database with linked tables from an MRP application. I need access
to create a unique order number for our RMA process. The problem I am having
is getting the data back into our linked table so the user can see the new
order in our MRP application.
Here is what I have tried -
I created a form with the Customer_Order (linked table) as the source. I am
able to see all the orders currently in the system but if i try to add a new
order I get a ODBC insert error.
I also tried creating a different form and storing the data in a table I
designed and then using an append query. But I would get key violations.
Any ideas how to get this unique number and other data into my linked MRP
table? Thanks for any help.
to create a unique order number for our RMA process. The problem I am having
is getting the data back into our linked table so the user can see the new
order in our MRP application.
Here is what I have tried -
I created a form with the Customer_Order (linked table) as the source. I am
able to see all the orders currently in the system but if i try to add a new
order I get a ODBC insert error.
I also tried creating a different form and storing the data in a table I
designed and then using an append query. But I would get key violations.
Any ideas how to get this unique number and other data into my linked MRP
table? Thanks for any help.