Duplicating Database Forms

[myjlmacy]

Our databases are set up annually for the different types of contracts. I need to duplicate the database (table and form) for 2012. The table is simple to duplicate without data, but I get errors every time I try to duplicate the forms for 2011 to 2012 forms. Help!

[jzwp11]

Welcome to the forum!

Our databases are set up annually for the different types of contracts.

Why would you do that?

You should have all contracts for all years in 1 database. What do you do if you have to find details of an old contract, and you do not remember the year?

[myjlmacy]

We use the database as the number generator and every year those numbers change based on the last two digits of the year. If there is a way to create a data base that will do differently I am open to it. Thanks for responding! I have been out for the holidays.

[jzwp11]

You can always record a date and extract the last two digits of the year. One way is with the following expression.

right(cstr(year(date()),2)

The date() function just returns the current date, the year function pulls the year from the date the cstr() function converts the year to a number and the right function pulls the last two characters.