I have DeliveriInformationTable which includes fields
DeliveryDate---This is set to current date
I have built a form based on the above table. What I am looking for is to have the same Invoice number for the Delivery information entered on the same date.
If I enter 10 delivery information, all those 10 must have the same invoice number in a format like "CurrentYear""0000". It must start at the above format. If it was next year again it must start at "CurrentYear""0000".