Ok that would work - was trying to make it too difficult but that will work -
thanks


PieterLinden 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
[quoted text clipped - 8 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.