Available Fields

[ericjsr]

After creating tables with various information, I wanted to create a table that will look to the other tables for the information. When I do, all of the fields in the other tables are not available. Why? Is there a way to get all fields available ?

[orange]

Can you give us an example of what you are doing?
Have you research SELECT query?
http://www.techonthenet.com/sql/select.php

[ericjsr]

I have:
Table1-customer name, address,contact info
Table2-Technician initials
Table3-Test set info
Table4-model info

I want Table5 to be able to lookup information from these fields and also the end user to add additional information as necessary.

File too big to upload...

[orange]

You have give a few tidbits of info about HOW you have done things. Please describe the application so we understand WHAT you are trying to do.
We only know what you tell us, so we're only guessing about your application and environment.

[ericjsr]

I made a table and tried to use the Lookup & Relationship item from the properties. Then I selected I wanted to use information from other tables (the ones I already created). Then I tried both the tables and the quaries view ( both separate and the both option). The problem is that no matter which view I choose, the fields from other tables are not showing up. The available fields is not populated with what I made in the other tables.

[ericjsr]

I have attached the database of what i have so far. I want to create a table that has all the fields available that I already created.

[orange]

I have acc2003 and can not use/read an accdb file.

[ericjsr]

If I change it to a .db will you be able to see it? Will it be the same?

[orange]

If you have not used special features only available to Acc2010, I think you could save a copy in Acc2003 format (mdb).