-
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...!!
-
Take a look at junction tables, that's how you connecttables with a many-to-many relationship.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules