Mr. B, thank you for your help, that website looks very useful.
I would like to do this on the table level because I eventually display that information within queries and forms. I personally would perfer to have the "current" field be stored with the rest of the data. However, if that is...