Here is one I've pulling my hair out on for some time now.
I have a quote database which auto seralizes the next quote, i.e., 1001, 1002, 1003 etc.. Because the main quote can be comprised of multiple sub quotes, I have a line items quote file (portal) which I also need to auto searlize. Here's the catch, I need it to happen in this fashion: When I generate a new sub quote in the line items portal it will carry over the main quote #, i.e., 1001. However, I need it to come up as 10011 in the first portal row. If I have a second sub quote it should come up as 10012, 3rd sub quote 10013 and so on. The process should then repeat itself on the next quote - 1002, sub quotes would be 10021, 10022, 10023 and so on.
Does anyone know of a way to acccomplish this? If so, it would be fantastic.
I've attached a sample quote file to help better understand what I'm trying to accomplish.
Thanks in advance for any help on this.