How To Get A Field Automatically Populate Another Table

[ProgEval]

Here is my current table set up. In the Client table I have a ID field and a region field. Alot of other client data exists in this table, too.

I then have a service table where service data is data entered through a form. The relationship is set between client ID. I want to have the client's region field in the product table without having it data entered for each service. I know I can manipulate the data through a query, but how do I do I pull this so its automatically in the service table? I have done it by accident before, but can not figure it out now.

tblClient
-ClientID
-Region
-OtherClientData

tblService
-ClientID
-ServiceFields

Any help is very much appreciated! Thanks!

 

[Remou]

Access will automatically fill in Link Child Fields with data from Link Master Fields. You can have more than one link field and / or control. Is this what you mean?

 

[ProgEval]

Maybe. How does my relationship need to be set up get that region field to automatically fill in the service table? Currently I just have a relations from ClientID to ClientID. What else do I need to do? Its not currently working. Thanks!

 

[Remou]

You need a form and a subform, the subform control would have the following properties:

[tt]Link Child Fields: ClientID; Region
Link Master Fields: ClientID; Region[/tt]

 

[ProgEval]

Got it to work. Awesome. Thanks so much!