Total noob question

J

JB

Hi,

I have a requests table and a shops table and the shop name field is linked
in both tables. When I choose a shop on the request table, I'd like the phone
number and contact name from the shops table to come up automatically. What's
the easiest way to do this?

Thanks
 
W

Wayne-I-M

Don't link the Shop Name - link the primary field of the Shops table
You "may" have 2 shops with the same name (if not now, then one day)

Create a form based on the tables (both of them - that 2 forms)

Open the request form in design view - use the toolbox to insert a subform
From the list select the shops table

I assume that the shops ID in a field in the requests table ??
 
J

JB

I don't think I want a subform, I just want a control that automatically
shows the contact name and another control that shows the number when you
select the shop on the request form.
 
W

Wayne-I-M

OK - my fault I thought you had 2 tables with shop details and another phone
numbers - sorry

If you have all the information you need in 1 table.
Use the wizard to create a form
Open the new form in desgin view
View the toolbox
Add a combo box
Use the wizard to "select a record on the form"
Ensure you select the ID "and" the shop name in the combo wizard

Enter the name of the shop into the combo and press enter - all the info
will show on your form
 
J

JB

I tried to use your advice, but the wizard doesn't come up. The control
wizards button is highligted, but i don't get the form wizard or combo box
wizard.
 
W

Wayne-I-M

Open the new form in design view
Select View
Select ToolBox
In the ToolBox select the combo box option
Follow the instructions in the wizard
 
Top