how to automatic display next record from a different table

B

BenVe

Hello there,

Altough I can develop a pretty simple database now I am running into a
little problem. This is what I am trying to do. I have 2 tables, called
inventory and location. Every article has a unique number. Now I am trying to
fill another table with data from both tables. So when I key in the article
number it should automaticly display the article description, location
etc.etc. Its like keying in the customers phone number and his whole adress
shows up on screen.
 
W

Wayne Morgan

Yes, this can be done, but do it with a form, not a table.

To do this, set up a combo box in the form's header (you'll need to go to
the View menu in form design mode and select to view the header). The row
source of the combo box should include the article number field. The form
would be based on a query pulling data from both tables. For this to work,
the tables will need a common, linked field. When you select the aritcle
number in the combo box, you would use the combo box's AfterUpdate event to
move the form to the desired record using that article number as the search
parameter.

For an example, see this link:
http://www.mvps.org/access/forms/frm0005.htm
 
Top