I hope I can get this question answered. I have my database for the members of our organization and every year we hold a convention. 2016 was the first year using access to handle my registration. The 2016 registration went well. Now I'm setting up for the 2017 convention. I learned how to place a second order from one of the 2003 Developer301 series, so it might be answered when that lesson becomes available. My problem is that when I place a reservation to a member who was at the 2016 convention and they want to attend the 2017 convention, I can place the registration but it now shows two member pages. Ex: If I do a report of our members, if that member was at the 2016 and the 2017 convention their members page will be listed twice. I don't think that is right. It's like having two data entries for the same person. How can I fix it. My convention is in November.

---

Reply from Alex Hedley:

Which Developer lesson are you waiting for?

So you have a record showing a user was at the convention in 2016, they are now at the 2017 as well are you wanting another record to show this?
Is it the same details on the year has changed? You might want a table that stores the years then a junction table to say MemberID | YearID and base reports on that.