AnsweredAssumed Answered

Increase Value of Field on Another Table

Question asked by J.S._1 on Feb 3, 2013
Latest reply on Feb 21, 2013 by philmodjunk

Title

Increase Value of Field on Another Table

Post

     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!

Outcomes