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

I already have a table called client and seems to be related with other tables ,I tried making TBL client as lookup too, I ended up having another table called Client_1?

P: n/a
Hi5
Hi,

I am working on a project in access 2000, Whilst I already have a table
called client and seems to be related with other tables ,I tried making
TBL client as lookup too, I ended up having another table called
Client_1,The question is:
1- How it created?
2- this Why is this table in relationships view and not anywhere else?
3- Is it the same table as client?
4-can I remove One of them?

Kindest Regards
Many Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi5 wrote:

I am working on a project in access 2000, Whilst I already have a table
called client and seems to be related with other tables ,I tried making
TBL client as lookup too, I ended up having another table called
Client_1,The question is:
1- How it created?
I don't know. I've found that when I create severl relationsips from
the same table in the relationships window and then come back, I have
the same phenomenon you are describing.
2- this Why is this table in relationships view and not anywhere else?
If this is where you are seeing the table, then don't worry. The
graphic method of representing the relationships you set up somehow gets
confused by the relationships we've set up and has difficulty rendering
thee relationships into the diagram on the relationships window. It
therefore creates an image of a copy of the same table.
3- Is it the same table as client?
Yes.
4-can I remove One of them?


If you do, you will eliminate the corresponding relationships.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #2

P: n/a
Hi5
Greate, Many thanks

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.