Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to split big database diagram on many pages?

Status
Not open for further replies.

ETN

Programmer
Jan 27, 2004
33
CA
I am designing a big database (over 200 tables). Having all thoses tables is quite hard to read. I can separate my tables on separate pages successfully but I would like to be able to have on each pages the tables for a particular process (i.e. Clients tables on a page, Vendors tables on another).

Creating the main tables on each pages is not a problem but my problem is that I want to make some relationship with secondary tables (i.e. Countries) and I do not know how to use the tables that have been created on a page in others pages.

So let say I have on the Client tables page a table named: Countries, how can I use (relationship) this table on my page tables named Vendors without creating a new table?

Is there a way to work with this and what are your suggestions or way you do it?
 
Just to be more clear:

On the client page:

table clients:
.id_client (PK)
.id_country (FK from table countries)
...

table countries
. id_country (PK)
...

...other tables

On the vendors page:
table vendors
.id_vendor (PK)
.id_country (how to make the relationship?)

I could want to make a relationship with my table Countries in others pages also...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top