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?
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?