relationship problem

[dhir77]

hi all
i need the help regarding realtionship between tables.i have 4 main
tables with one to many relationship - result,sample,site,location as
location can have many sites,each site has many samples,each sample
have different results.there are few other tables like analyst,site
type etc which have one to one relation ship with one of the above
tables.
now problem is when i define relationship between tables and save
them.if i press show all the lot of other tables like site_1,Sample_1
etc are also shown in the relationship window.
can anybody explain whyit is so and what is the solution
thanks
anil

 

[Guest]

A table called site_1 will appear in the relationship window if the table
site is added twice.

Delordson Kallon
http://www.instantsoftwaretraining.com/

 

[dhir77]

thanks a lot

 

[John Vinson]

hi all
i need the help regarding realtionship between tables.i have 4 main
tables with one to many relationship - result,sample,site,location as
location can have many sites,each site has many samples,each sample
have different results.there are few other tables like analyst,site
type etc which have one to one relation ship with one of the above
tables.
now problem is when i define relationship between tables and save
them.if i press show all the lot of other tables like site_1,Sample_1
etc are also shown in the relationship window.
can anybody explain whyit is so and what is the solution
thanks
anil

As Delordson says, if you have two relationships between the same pair
of tables (e.g. if Result is linked to Site TWICE) you'll see an alias
name for the second instance.

One common way this can happen is if you've been misled into using
Microsoft's Lookup Wizard. It will create a new relationship between
the tables you're using for the lookups - even if a relationship
already exists.

You can clean this up by selecting the redundant join *LINES* (not the
table icons but the lines) and clicking the Delete key. You can then
delete the now disconnected extra table icon.

John W. Vinson[MVP]