Hello,
I have a training database that I have set up and utilize to track attendee data and who is registered to which course.
I have a course registration table that has a course title field which is a drop down list populated by course titles from the courses table, and a trainee id field.
For whatever reason, when I view reports or queries that draw from this table, access will make changes to the first record in the course registration table course title field i.e. it will take whoever is in the first record, and change the course they were registered to.
Any insights in to what might be causing this would be greatly appreciated.
I have a training database that I have set up and utilize to track attendee data and who is registered to which course.
I have a course registration table that has a course title field which is a drop down list populated by course titles from the courses table, and a trainee id field.
For whatever reason, when I view reports or queries that draw from this table, access will make changes to the first record in the course registration table course title field i.e. it will take whoever is in the first record, and change the course they were registered to.
Any insights in to what might be causing this would be greatly appreciated.