Increase Value of Field on Another Table
I have a field called Proposal_Number on my table called Proposals, which is populated based on a calculation that includes the two-digit numeric value of the Rep_Count field on the Reps table. I need the value of Rep_Count to be increased each time a proposal is commited, so the next proposal number would include the increased value. The other requirement is that I need the value of Rep_Count to reset to a value of 01 each day. Thanks!