Data Extraction and Import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I am trying to build a booking system for my new company. We use a tour
reference number to identify the customer.

We enter information when we first receive it, and assign it a Tour
Reference Number. We then use different forms to enter information in
stages.

I want to be able to select the tour reference number from a drop down box
(which I have already set up). When, having clicked on the appropriate Tour
Reference Number I would like the information related to that number in
another table pulled into the table I want to add it to.

Put simply, I have a table with Tour Reference Number, Name, Address, and
Telephone Number. I want to use a form to select the number from a drop down
box and have the name, address and telephone number related to that number,
imported into the new record in the table without having to type anything!

Hope someone can help, and hope you can understand what I mean!

Regards,

Dave
 
Thanks for that Ken, worked a treat. Just one small problem now. When I
have selected the record I want and it has pasted the information I want into
the fields, I complete the record and save it.

However, when I come to issue a report on that table, it doesn't print the
fields that have been looked up from the other table!

It's probably something really simple, and thanks for being so patient!

Regards,

Dave
 
It's not clear to me what you mean by "doesn't print the fields that have
been looked up from the other table".

What is the query that you're using for the report? What are the structures
of the tables that are involved?

Are any of the fields in the tables using "lookup fields"?

--

Ken Snell
<MS ACCESS MVP>
 
Back
Top