Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: Does this relationship structure work?

    Hi everyone,

    Attached is a snippet of a much larger ERD that is being produced for a (fictional) national group of car dealerships. The attached snippet relates to the marketing events that the group run:

    Does the relationship structure that I have used work?
    Attached Thumbnails Attached Thumbnails Invitations.Attendance Relationship Structure.jpg  

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    work through each table
    work through each link and decide for yourself
    if needs be put in some sample data and see what happens

    incidentally Im surprised you are not enabling the 'Enforce Relational Integrity' iption whne defingign the keys. there seesm little point in using a realtionl DB such as Access and not use the RI capabilities
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •