Trying to Setup an Automatic Number Generation

J

Jennifer

I have several tables and forms relating to this complaint
database that I created. I have an automatic number that
generates with each complaint that is initially entered.
Then if there is a return associated with it, a separate
form is filled out referencing that first automatic
number. However I need to generate another automatic
number for that return # to give to the customer. This
ensures that the are approved before the customer actually
returns it. Does anyone know how to easily do this?
Currently I manually have to go in each time there is a
request and put the number in the file. All the return
and initial complaint information are in one table. Any
help is greatly appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top