I have a query with 2 tables. When the relationship is 1 to many, the recordset is updatable and life is peachy.
When the relationship is many to many, it now tells me that it is not updatable.
Technically I do not need to update anything from table #2. I am pulling in 1 field from that table so that I can have a "flag" on the record to let the user know that something exists in table #2 for that record. Since my Access form is datasheet, I use Conditional Formatting to make it RED when something exists. The problem is that now that I am adding Table #2 to the query, the recordset is not updatable. So, we cannot make changes in the form.
Any ideas how I might either fix the problem or work around it?