Relationships and _1 Tables

[blyxx86]

I've been creating some lookup values to tables, but for whatever reason it is not creating that 'phantom_1' table like it sometimes did. So now it is creating a relationship to the original table instead, which just makes my relationships look messy.

Am I missing a step in creating a lookup field? I ask because I have 3 tables that all store some of the same information (hence the reason it is in a seperate table) but two of the tables do not need to be related to the lookup table, just function as lookups to the table. Does that even make sense? I'm not going to need to create any type of subform with the two tables, only the first.

I'd love for some advice on this.

Thank you,
Kyle

[nico5038]

The 'phantom_1' table is just created when you already have a 'phantom' table. That's needed for Access as it doesn't allow multiple relations to the same table as it needs internally unique identifyable relationships, although in both cases a relation to the same physical table is created.
Thus there's no need for a phantom table when you have just one relation.

Nic;o)

[blyxx86]

The 'phantom_1' table is just created when you already have a 'phantom' table. That's needed for Access as it doesn't allow multiple relations to the same table as it needs internally unique identifyable relationships, although in both cases a relation to the same physical table is created.
Thus there's no need for a phantom table when you have just one relation.

Nic;o)

I guess what I'm trying to say is that I can't seem to get any of those Phantom_1 tables to appear. They used to, but not anymore.

Did I change a setting somehow? Or do they not show up in .mdb files from access 2000? I'll have to play around with it some more. I liked them because they helped for creating lookup tables and clearing the clutter.