Saving a Record with Aggregates

[whdyck]

I'm using MS Access 2003.

I have a pair of tables in a typical Master/Detail relationship. (I'll call them M and D). I also have a Continuous form displaying records from table M with aggregates from the related table D. (Record Source is a query that joins the two and creates the aggregates.) Problem is that because of the aggregates from table D, I can no longer make changes to table M and save in this form.

I should say that I need the aggregates in order to filter the Continous form on records from M that have incomplete records from table D.

What are my options, if any?

Thanks for any help you can give.

Wayne

 

[RainLover]

Perhaps a Main form and a Sub form.

M info goes into the Main and D into the sub.

Don't join the tables in a query.