Update automatically

[jbphoenix]

I have linked several table from an MRP application. I have created a form
in access and would like the data the user inputs on the form to update the
tables in the MRP application. The data needs to go to several different
tables in the MRP. How can I set something up to automatically update the
tables in the MRP application. I used access to create a unique order and
RMA number. The user fills out the form and the data needs to appear in the
MRP so they can finish the RMA process. We need access to create that RMA
ID. The RMA ID consists of the number preceeded by a letter (A,B or C). The
letter is based on if the RMA is a credit or replacement.

Thanks