Querying between tables to return to a form

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

Hi

I am trying to get a better understanding of Access and have the following
issue I cannot work out.

I have two tables

Table 1 is called Customer Details and contains the following

Account number
Title
Surname
Firstname
Postcode
Phone number

Table 2 is called email details and contains the following fields

Account Number
Email address

There can be more then one email address with for account number.For example
Account 1 may be listed several; times with a different email address in
each.

What I want to do is build a form which shows all the customer details and
all the email address`s based on the customer account number

I have a form made , but cannot get the list box I have assigned to show all
the email address`s wheich coresspond to the customer currently bening
displayed on the form

I have tried writing a query , but cannot get the email address`s to appear
in the list box. Any guidance greatly appreciated

Brian G
 
Thanks Tina

I should have remebered th golden rule "KISS". Im sure that I used a query
for this before. never mind , im there now.

Brian G
 
Back
Top