Field Names in relationships in 2 tables

[HL]

I know that I have to create two tables, one for customers and the other for branches.

The relationship will be one to many (one customer has many branches) in the second table I would like to see the company name instead of the company id.

How do I go about this?

 

[Kraj]

You don't. The tables are not meant for viewing, only for holding the data in the most efficient and stable way possible.

Instead create a query that selects the company id from table 2 and matches the company name to it. Then create a form or report based on that query. Depending on what you need to do, there might be other solutions as well.

 

[HL]

Ok I have lost the plot on this one.

Ok I have created the query.

I have pulled the company name from the tblcompany into the query and saved the query as qrybranch.

I have created a form and have used a combo box to choose the data from.

When I add a company name I would like that name to go into the branch table -tblbranch record set along with address details

I have attached a demo so you can see what I am doing wrong!

Thanks

 

[HL]

At Last I have sorted out the problem!!!