Index Auto-Increment not working

  • Thread starter Thread starter davie24
  • Start date Start date
D

davie24

Having trouble with auto-incrementing index. Everthing was working
fine until I converted the back-end DB to mySQL. Now my record #
number index does not show until after I save the record, but I need
that index number for other tables while I'm entering data. Is there
anything I can do to get this to work?

Thanks
 
Having trouble with auto-incrementing index. Everthing was working
fine until I converted the back-end DB to mySQL. Now my record #
number index does not show until after I save the record, but I need
that index number for other tables while I'm entering data. Is there
anything I can do to get this to work?

Thanks
Click to expand...

That is how auto-increments in server databases work. All you can do is
save the record at the earliest point after all required entries have been
made so the value will get assigned.
 
You must log in or register to reply here.

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

Similar Threads

auto number index snafu 6
Auto Number Problem 4
Losing Table Index 3
Increment "text" not number 2
Primary Key Field (Auto Increment) is Creating Duplicate Record Va 10
VBA – Form Field Question 10
Auto fill not working 2
Auto Increment issue 2

Back
Top