By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Relationships and _1 Tables

blyxx86
100+
P: 256
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
Feb 26 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Feb 27 '07 #2

blyxx86
100+
P: 256
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.
Feb 28 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.