Update question

[oakoen]

I have 2 tables.
customer and service that are joined.
Customer has fields companyname and id(pk).
Service has fields companyname(lookup of name from customer table) and cust_id(joined to id in customer)

I have a form which uses the table service. The form uses field companyname to lookup and select a customer.

How to I get the ID(from customer) to populate cust_id(service) to update automatically when companyname is selected in service?
I hope I made that understandable.
Thanks for any help

[dcrake]

For a start do not use the word Name as a name of a field in a table. This is an Access reserved word. You need to be looking at reserved words and naming conventions. This may be the root of your problem.

David

[oakoen]

I wrote "name" to shorten the post. I have edited my previous post

[dcrake]

How is your relationship set up?

Is it a one to one
who is the parent

From what I gather customers can belong to compainies

So you should have a table of companies
A table of customers with a FK back to the Companies PK

Then your services has a FK back to the PK in the customers table. So by selecting the customer it will automatically know which company they belong to. Assumiong that one customer can only belong to one company.

David