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

Hi5 wrote:

[color=blue]
> 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?[/color]

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.
[color=blue]
> 2- this Why is this table in relationships view and not anywhere else?[/color]

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.
[color=blue]
> 3- Is it the same table as client?[/color]

Yes.
[color=blue]
> 4-can I remove One of them?[/color]

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

Greate, Many thanks