Automatically create a Booking_ID

[vflorian19]

Hi All,

I have created a booking system where the Bookong ID should be generated automatically.
It is saved to the system this way: I do a search for the existing ID’s sort it desc. taking the first item and add + 1.

The result which is saved to the DB is always 1
I am pretty sure this should work, because a few moths ago where I have left working with this system it was working. What is wrong now?

Please help Thanks

[Sheila123]

Have you tried using Booking_ID=Search for Bookings:last items Booking_ID+1. I suspect that might be it.