Software

Ask something
Question Locked

Acess lookup table

0 helpful
5 replies

by megahertz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello, This is a basic question that I have not been able to find an answer in the help files.

I have a "workorder number" field in table 1 and also a separate a work order table.

When I enter the workorder number in table 1, I want it to go to the work order table and pull in information such as client name, client number etc. so that I don't have to type it in. Thanks,

5 replies

by megahertz

I forgot to mention I have Access 2000.

I looked for "Master Detail" in the help file but nothing relevant came up, unless I misunderstood your suggestion.
Thanks,

by tony hopkinson

Hmm always used to.

Master Detail is a classic layout, and access has a good bit of functionality to implement it.

For instance you have a table of customers and when youi select one of them it shows another table of orders for the selected customer.

This should help

http://www.profsr.com/access/accless09.htm

by larryd4

You need to set the relationship between the two tables. Then you can generate a form that will display the data you want and include the data from the other table.

This discussion is closed to new replies.