Results 1 to 2 of 2
  1. #1
    josephbupe is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    1

    How to associate persons

    I am creating a database for my local Police authorities. Pretty new to database programming but I have already done considerable progress on it. The database will be tracking suspects/criminals information, crimes committed and exibits (attachments). Up to here I have no problem.



    The problem is how I can create a relationship among these suspects/criminals if they belong to same syndicate and also with their family members etc.

    For interest sake, I would like to see some screen shorts of any existing criminal database, whether there any standards i should follow in the set-up of controls on the forms (person's portrait, crimes, bio data etc). I have tried searching the web but can't find anything close to this.

    The screen short attached is what am working on...ideas from movies...!!

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Take a look at junction tables, that's how you connecttables with a many-to-many relationship.

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

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