Updating Access 2003 forms based on distinct queries
Posted on 2011-04-27
I have a form based on a two table query. The tables are 'Teachers' and 'Classes' (A teacher can teach many classes) so the query returns an entry for each class taught. This means that if a teacher teaches 3 classes, the teacher will appear 3 times in the form. This is not ideal.
I only want to see a single entry for each teacher who is running class(es) so I did a SELECT DISTINCT on the Teachers primary key field. It worked but it now means I cannot update the form.
I am completely stumped as to what to do about it. I need to be able to update a field on the form (originally from the Teachers table) but cannot.
Thanks in advance,