Phantom(?) Tables in Relationship View 1

[Patrix]

G'day folks, apologies if this is a dumb qn, but I haven't found the answer in all my Access reading yet (mainly because I don't know what to call them, to search by).

Occasionally when building a database, you look in the Relationship View and see extra tables (copies of existing tables) created in the view, with names the same as the copied table WITH "_1" or "_2" etc tacked on the end. eg "PRODUCT_1" "STUDENT_1" etc.

They seem to get generated from some Queries, and the database does not seem to suffer without them (is this niaive?).

What is the technical term for them? Phantom??? Extra????
What instructions actually generate them?
Why are they there - what purpose?
Consequences of removing them?

 

[montrose]

Patrix, Those "phantom" tbls are the indirect relationships that are created from your queries. If you don't want to see them, click on "Show Direct". "Show ALL" will put them back into view for you. HTH, Montrose Learn what you can and share what you know.