Results 1 to 6 of 6
  1. #1
    samdahlr is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2014
    Posts
    28

    Relational databases

    Hi,



    I have six customer databases that are all related. They have some of the same contacts with the same email addresses or ID's for example. When I view there relationships in access shouldn't they be related? This is what I am getting.

    Thanks

    Click image for larger version. 

Name:	Capture.PNG 
Views:	26 
Size:	47.1 KB 
ID:	17543

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You dont HAVE to relate them. It still works.
    Now, if you want to use them, it would be mainly to keep parent records from getting deleted an leaving all 'orphan' child records still in the table. (handy)

    I rarely use them since none of my records get deleted. (plus sometimes its a pain to change design with relations on)
    But its good either way.

  3. #3
    samdahlr is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2014
    Posts
    28
    Shouldn't there be lines connecting the different related fields?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Establishing relationships is not critical to a functioning database. If they are established, then when you build queries Access will apply the established links. You might appreciate that or might find it annoying when you want the link to be the other way.

    Also, establishing links allows you to set Enforce Referential Integrity and the associated Cascade Delete and Cascade Update.

    Many experienced developers choose not to set relationships for reasons expressed but ranman and instead control integrity with code and preventing user interaction directly with tables and queries.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    samdahlr is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2014
    Posts
    28
    When you say it will "apply the established links" do you mean that it will organize the data the based off of the links? How exactly does that work? I am trying to merge these databases. Each database has lots of the same fields but some that are unique to that specific database. In the master database where I am merging the data I am going to add about 2 of those unique fields from each database. There are a lot of common contacts between the databases so I do not want to just pile all of the records on tip of one another if I can combine them based on those common fields.

    Thank you.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I mean when you pull the tables into query builder the link lines will be set by Access based on the relationships. Will not 'organize' the data, just joins records. Then you pull the desired fields down to grid.

    However, I think in other thread you indicated you need to UNION the tables, not JOIN, therefore PK/FK linking is irrelevant and relationships serve no purpose.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Relational Database
    By javier571 in forum Database Design
    Replies: 1
    Last Post: 04-13-2014, 07:05 AM
  2. Double Relational
    By jammmie999 in forum Access
    Replies: 1
    Last Post: 05-19-2011, 01:37 PM
  3. Relational tables - again
    By BarbT in forum Access
    Replies: 6
    Last Post: 10-31-2010, 10:28 AM
  4. Relational tables help
    By BarbT in forum Access
    Replies: 5
    Last Post: 10-21-2010, 09:03 AM
  5. Relational Database/query help
    By Champin4 in forum Queries
    Replies: 7
    Last Post: 07-14-2010, 08:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums