Sequential numbering help
My database has a date field, year field and numberfield. The number field is set with DMax which will reset to No.1 when the year changes. I want help on the following:
For current year's records - The DB should use the current year's records only for actual working i.e. data entry, edit, search, print etc.
For previous year's records - The DB should allow only search and print and NOT for data entry and edit.
How can I achieve this. Please help.
|All times are GMT +5.5. The time now is 10:30.|