multiple auto numbering systems
I have seen similar posts but the situation is either different or I couldn't follow the formulas that were posted so I apologize if this is redundant. I have a [Project Number] field that is a for...
Forum Discussion
Hi Surya,
I'm following you up to the part where I pull look up fields of # of Projects for each type back to the Projects Table. However, what is the reason I need the max value for A? The max function takes the max of a set of numbers but what numbers is it picking from other than the number of each project type? There's only 1 option now so the function doesn't work. Also, what is the purpose of taking the Right 5 characters? Please help clarify.
Thank you
I'm following you up to the part where I pull look up fields of # of Projects for each type back to the Projects Table. However, what is the reason I need the max value for A? The max function takes the max of a set of numbers but what numbers is it picking from other than the number of each project type? There's only 1 option now so the function doesn't work. Also, what is the purpose of taking the Right 5 characters? Please help clarify.
Thank you