HI guys,
I am working on a simple billing database. I am having a tblBill, which has access defined PK and I have also added a field BillNumber , which has property set to Indexed & No duplicates. Bill Number is entered by the user.
Now Supposedly last bill number is 51 dated 5th-January-2018, Now I want to control that Bill Number 52 cannot be dated prior to 5th-January-2018. I am using forms for the input.
Kindly guide me in the right direction.
Thanks and Regards
Deepak Gupta