Cannot find tables
I am working with a ms access file. When I look at the objects in the access objects window using a category of "object type" I only see one table, when I use the category "Tables and views" I see three tables, these extra two tables are in the dropdown list if you try to create a new relationship. I do not understand where these tables are and why I do not see them using category "object type"
Software/Hardware used:
Software/Hardware used:
ASKED:
October 12, 2012 6:16 PM
UPDATED:
October 12, 2012 6:34 PM
Answer Wiki:
In my own perecption I think the other two tables have been hidden in the group of Tables( Under object Type category) Because you have indicated that when you try to create a relationship the two tables which was missing appears in the drop down list, I guess I got you right.
All Answer Wiki Contributors:
JohnKennedy 
405 pts. ,
Michael Tidmarsh 11,405 pts. ,
Chucky666 5 pts.
405 pts. ,
Michael Tidmarsh 11,405 pts. ,
Chucky666 5 pts. To see all answers submitted to the Answer Wiki: View Answer History.
It soulds like you have one table and two views.
The views present data from one or more tables, they may limit the columns and or rows from the table or summarize the data. You should be able to recognize that the view data is similar to the table data because it is the table data. Once views are created they can be used in making reports, queries, forms.