Can a table retreve information from another

[MrMcFestoe]

I have a table with customer details in it, i need another table with some of the customer details plus additional information. I have made a query to extract the information from table 1 but when this is viewed on a form any changes on the form do not update the information. Is the reason because it is a query?

Can you have a main table that transfers certain information into another, and when one of the tables is updated updates both tables.

Iam asking to much.

 

[fneily]

Your query is "bound" to table 1, so the form using this query is "bound" to table 1 not the 2nd table.
You're also repeating customer details in two different tables. PLEASE study normalization. It sounds like you should have one table of customer details and another table with the details. They would be connected by a "key", ie. let's say the customer table has a primary key called custno. Then custno would be used as a common field in your detail table. It would create sort of a "path" (actually, a link) between the two tables. Then you could create a form with a subform and this would solve your problem.

Neil

 

[Zion7]

Also, "Auto lookup query" should perform this action. Read about it in Acces "help". I'm having the same problem, and am in the process of tryinq "Auto lkup Query" good luck! Of course the subform will work also like fneily said.