Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / July 2005

Tip: Looking for answers? Try searching our database.

Duplicate tables in relationship window?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Access - 29 Jul 2005 10:43 GMT
I have about 300 tables in my relationship view.
Because a number of tables are used in more than one "portions" of the db,
to make the view more comfortable, I duplicated these tables in the
relationship view, such as tbl1, tbl1_1 (_x is a suffix by access).That way
in one side I link to tbl1 and in another I link to tbl1_1. The question is:
is there any problem by using duplicate table views, aka in relationships,
RI etc???

Thanx in advance.
Nikos Yannacopoulos - 29 Jul 2005 11:08 GMT
I believe duplicates are just for display purposes, in fact behind the
scenes it is just the same to Access.

Nikos
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.