Tables named Domain

  • Thread starter Thread starter colmkav
  • Start date Start date
C

colmkav

Can anyone explain how the following is possible? An Access db I am
analysing has 3 tables called "tblDomain", "tblDomainLookup",
"tblDomainType" and a whole load of other tables with other names none
with "domain" in it. When I look at the Relationships diagram however,
I see 8 different tables named "tblDomain_1",
"tblDomain_2"....."tblDomain_8" each with a different mapping to a
table called "tblSecurityInfo". Each of these "tblDomain_$" tables
have the same structure.

Whats going on here exactly. Why do these 8 tables in the relaionship
diagram not appear as physical tables in the table tab of the database
window?

Colm
 
hi Colm,
Whats going on here exactly. Why do these 8 tables in the relaionship
diagram not appear as physical tables in the table tab of the database
window?
Click to expand...
The relationship window is not capable of displaying multiple relations
between two tables. Therefore it displays the tables multiple times
naming them tablename_N.


mfG
--> stefan <--
 
hi Colm,


The relationship window is not capable of displaying multiple relations
between two tables. Therefore it displays the tables multiple times
naming them tablename_N.

mfG
--> stefan <--
Click to expand...

Thx Stefan, Still confused in the sense that each of these Domain
tables (or the same Domain table) are linked to the other table via
their "domainID" but to different fields of the other table.

eg

tblSecurityInfo tblDomain_1
(fields) (fields) tblDomain_2
ProdCodeID <------> DomainID
(fields) tblDomain_3
SectorID <--------------------------------------->
DomainID (fields)
SubSectorID
<--------------------------------------------------------------->
DomainID

Dont see how this can be possible?

Colm
 
hi Colm,
Thx Stefan, Still confused in the sense that each of these Domain
tables (or the same Domain table) are linked to the other table via
their "domainID" but to different fields of the other table.
Dont see how this can be possible?
Click to expand...
Nor do i. Without a data sample, it is imho not really possible to guess
what the E-R behind your modell is.

mfG
--> stefan <--
 
Back
Top