Hello everyone! I am facing issue with my delivery table as it only allow me to have one promised date = can only use dateadd function once for user to input the date in themselves. I would like the user to input two different date. How can i do that?
The first image: Purchase Order Form, and you will be able to see that in this PO form there are two type of fabrication with lots of colors.
The second image: Is the fabric delivery table that i am referring to and you can see that it has two different date with two different colors. The first delivery table ( 3/AUG) is based on the first fabrication(100% Cttn 28/1 1x1 RIB). The second delivery table (25/AUG) is based on the second fabrication (100% Cttn 16/1 Jersery).
I would like my table to look something similar to the second image.
The first image: Purchase Order Form, and you will be able to see that in this PO form there are two type of fabrication with lots of colors.
The second image: Is the fabric delivery table that i am referring to and you can see that it has two different date with two different colors. The first delivery table ( 3/AUG) is based on the first fabrication(100% Cttn 28/1 1x1 RIB). The second delivery table (25/AUG) is based on the second fabrication (100% Cttn 16/1 Jersery).
I would like my table to look something similar to the second image.