Is there a method I can use to total related child records for the parent record without making the records not updateable? A totals query gives me what I am after, but you cannot update a totals query.
Long story short, I am adding cost modifiers to an original cost where the modifiers are in another table with a 1 to many relationship (1 base to many modifiers). Am I able to maybe do this totaling in a control on the form itself?
Long story short, I am adding cost modifiers to an original cost where the modifiers are in another table with a 1 to many relationship (1 base to many modifiers). Am I able to maybe do this totaling in a control on the form itself?