Help with My Query

[Pat Hartman]

So you changed the query from a left join to an inner join.

 

[mike60smart]

Hi Pat

Yes

 

[Pat Hartman]

That was easy. There were too many posts for me to read to figure out a problem that you said you fixed Life is too short.

 

[mike60smart]

Hi Pat

I am amazed that the Form actually allows it to be edited with the Record Source being based on a query with so many tables.

 

[Pat Hartman]

It isn't the number of tables that makes a query not updateable, it is the relationships. There is no Cartesian Product here. There are 2/3 lookups and 2/3 hierarchical levels. I don't remember the query exactly. I've got updateable forms with a dozen tables. Take a look some time at my "Bound denormalized form" sample. It lets you take a properly normalzed table and make it look like a spreadsheet for data entry and it is all done with queries.