I am getting really stuck trying to create a duplication button for booking equipment. I'm looking to create a new booking record and copy all the items added to the current (bookingitems) portal.
I need to find the last booking ID, add one to the serial (BK0001) and then copy all of the items across to the BookingItems list.
I have found similar questions on the community page, but i've not been able to get it working. If someone has advise on where to start that would be awesome.
I have attached pics of my test DB, but I'm sure i will have missed something important from this question, and sorry in advance for my ignorance. I've been using FM for a few years, but still get a bit stuck scripting.