how do you show all fields from linked data? only shows first one

  • Thread starter Thread starter fro5tie
  • Start date Start date
F

fro5tie

This might be a really simple question but I've tried searching and cant find
anything!

Ive got two tables, Customers and Jobs.
Customers has normal data - first name, last name, email address, post code
etc.
Jobs uses lookup wizard to get the customer data into a field called
Customer ID, and then there are other fields such as job date, description,
cost etc.
when im inputting data into the jobs table the lookup wizard is fine and
shows all the data, but when i actually look at the jobs table, or produce a
report it only shows the first field (first name, it hides the primary key
id).

is there anyway i can get it to show all the customer data in the reports
and the jobs table? sorry if i havent explained it very well, if you need any
more information please let me know and i will try!
 
This might be a really simple question but I've tried searching and cant find
anything!

Ive got two tables, Customers and Jobs.
Customers has normal data - first name, last name, email address, post code
etc.
Jobs uses lookup wizard to get the customer data into a field called
Customer ID, and then there are other fields such as job date, description,
cost etc.
when im inputting data into the jobs table the lookup wizard is fine and
shows all the data, but when i actually look at the jobs table, or produce a
report it only shows the first field (first name, it hides the primary key
id).

is there anyway i can get it to show all the customer data in the reports
and the jobs table? sorry if i havent explained it very well, if you needany
more information please let me know and i will try!
Click to expand...

I would suggest you take some time to learn the basics of using Access
before continuing with your project. There are a few issues with the
way you have things set-up and the way you are thinking about your
project. I would suggest taking a look at Crystal's Access Basics at
http://allenbrowne.com/casu-22.html.

Your first mistake is in using the lookup wizard in your table. It
leads to the sort of problem that you are encountering among others.
Also, the tables really aren't for looking at your data in a
meaningful manner. Tables are for storing data. If you want to look at
your data in an organized way, you need to make a query to connect
your Customer table to your job table. The query can pull the specific
pieces of data that you want from each table so that you can see them
all together. Ultimately, you'll want to build forms and report to
view/manage your data. Like I said, take some time to go through
Crystal's tutorials and learn about how Access works, it will save you
many headaches in the future.

Keven Denen
 
Back
Top