I have two tables and both of them have a field called PDR. The PDR is in the following format (nnnnyy),like this '000103'. '0001' can be the auto number or add up by 1 for every new record. '03' is the current year. I can seperate PDR. That is, 'ID' field and 'year' field. Then combine them later.
The PDR field can be auto-number or something else. But I want the PDR number be radomly picked up for these 2 tables. That is if the new record in Table One gets '000103', then the next new record in Table Two gets '000203'.
The hard part is once we move to the next year,say '04', I want to reset the 'nnnn' to zero and start over again.
Thanks in advance.