Greetings,
I think I have a stupid simple question, but can't figure it out. I'm trying make a form where I associate two tables. My structure is:
Table A:
Tbl A ID Tbl A Name
Table B:
Tbl B ID Tbl B Name
Table C:
Tbl A ID Linked Tbl B ID Linked
qryJoin
Tbl A ID Linked Tbl A Name Tbl B ID Linked Tbl B Name
I can create a form that shows the query, and that it groups by either A or B. I then created a lookup field for the form so that a combo list would list all of the Names (for one or the other) if I try to change the value in the subform. The problem is, it won't update Table C when I do so, it just gives me an error saying unable to update.
When I hand jam the ID's into C, the fields all show properly in the form (to review data), but to create a new record, it fails. Is there a way to fix this without using VBA?
Thanks!