Hi kd2017 and all, I was wondering if you could help out on the creation of "next highest" new request number and/or sub-request number related to the associated request number. I am including a mock up db so you can see that what I have seems like it is working but as kd2017 explained on #4. I tried the suggested code on #5 as pointed out by kd2017
Code:
=Nz(Dmax("Request_Sub_Number", "Requests", "Request_Number=" & [Request_Number] & " AND Requests_ID_Field_Name_here <>" & Requests_ID_Field_Name_here), -1) + 1
Unfoturnately, it still generates a wrong sub-request number if I am located on the wrong ID number. I am attaching my current db and hopefully someone can help me solve it. Very much appreciate any help. I cannot tell if db was attached correctly.
Truly kind gesture in this group
Alocin!