left join form issues?!
Greetings and thanks for reading this!
I have a bit of an issue. It has been a long time since I had to program in Access. My issue is that I want a form to display a list of items on the left, and using the left join be able to save attributes about the items on the left using the joined table on the right. HOWEVER the query doesn't seem to be updateable. What fundamental law of relational databases am I breaking here?!
Since the data on the left isn't changing it shouldn't save it. Why is the recordset read-only (right table)? To put it in better terms:
Students is the left table, if they ate breakfast is on the right.
The left join shows the student names by grade (via a filtered combo) - the right has the date (format(now(),"mm/dd/yyyy") as the default value - and a checkbox (yes/no) for whether they have eaten breakfast. The "breakfast" table includes a 1-to-many relationship - I am lost here. I have tried to use two different queries to produce the same affect to no avail this seems like the way to do it. I just can't see the mistake here.
Any suggestions welcome!
Thanks in advance!