Heyo everyone I thank you in advance for helping me.
So I have a table which has an autonumber field as the primary key. There is another field which the user has to manually enter that uses the value of that autonumber field plus some other information (yes I know that autonumber fields shan't be used in this way. I know that this is by far not the optimal solution, but I cannot change it. I just can't). We have a form in which there is a field that corresponds to the autonumber column, but that doesn't populate/isn't assigned until after the record is saved (it just displays "(New)"). I need that to populate when the user goes to make a new record, not after it's saved. Does anybody know of a way to do this? I'm fine with writing code to get this done.
Sorry for the disorganized thoughts,
EDIT: The list that the form is operating off of is hosted in sharepoint, so I think that's what's causing this
-John Lewis