Hello,
I have a form that has an option of packed bag or box, and with each selection it should automatically populate with the next available number based on the database. I have tried several things, but nothing seems to be working. I created a temp search table
to store the last number used for box or bag, but it still won't auto populate in the text box on the form. So if the last box that was packaged was box number 4, I need to text box to populate with number 5. Any suggestions
