kmerid59 wrote:
It is actually a table with field names. I want a new database because not
the same people register year to year and and we have to create credentials
and badges for those that do register, so i would like it that if you are in
my pastreg table and then i have 2010reg table that if i type in your member
nbr and you were in pastreg it would pull over all fields so that we do not
have to retype everything just verify add, phone, emal etc

I have a registration from that has numerous fields and would to like if the
register this year pull all the fields from old over to new db - I can either
[quoted text clipped - 10 lines]
normally you would have two tables, one for the static data and another for
the year to year changing data, in a one to many relationship?


Bad idea. Just add a year to the registration table and filter off that.

--
Message posted via http://www.accessmonster.com