autoupdate between fields

[Frank]

I have three tables noted below:

Customers: fields: lastname;firstname;street;city;state;zip

workorder: fields: lastname;firstname;invoicenumber;cost;tech;time

Action: fields: lastname; firstname;invoicenumber;cost


I have an entry form built on above tables.

first part of form has all fields in Customers table

the bottom part of the entry form has two subforms

first subform built on all workorder fields.
second subform built on all action fields


What I want to do is this:

If I complete the first subform, I want the second subform to
automatically update the invoice number and cost fields noted in second
subform. The end result is that when I move from customer to customer in the
entry form, a list of all activities in each customer noted in the subforms
will be displayed in datasheet view.

How do I do this?

Any assistance is greatly appreciated.

 

[Steve Schapel]

Frank,

This is very puzzling. Why do you want a table (Action) that replicates
the data that is already in another table? As far as I can tell, from
what you have told us so far, you should just delete the Action table
completely.