Please help me I am completely lost. I need access to assign the next available number based on criteria entered.
I am trying to assign numbers to some documents. Each document will have a number set up like AA - BB - CC - D (SEE CHART BELOW). The "AA" will be based on what document type it is (I have a look up for this), the "BB" will be based on what project it is (I also have a look up for this). The "CC" is where I need help, I need it to assign the next number in the series,
so ex:
31 - 12 - 22
31 - 12 - 23
31 - 12 - 24
Tables:
- Document Type
- Project Codes
- Document List
I am not sure what makes the most sense a Query, or formula in the table or what! Sorry I am very new so I probably didn't verbalize this well.