Results 1 to 3 of 3
  1. #1
    Midriss is offline Novice
    Windows 11 Access 2016
    Join Date
    Mar 2023
    Posts
    1

    Organization of Data

    Dear all,


    I am trying to create a contact management database for a government ministry. My ministry has different divisions. My contact table has fields for full name, email, and designation and another table for divisions with a divref field to reference each division. How can I get my data to reside by each division as all my new entries are listed by auto number subsequently with uniqueness. Thanks

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Your contact table needs a division field that holds, as a foreign key field, the autonumber pk field from divisions. That assumes that one person will only ever belong to one division at a time. If not, you need a junction table for divisions/contacts. Research normalization and junction tables if you're not aware.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I would recommend that you step back and make a rough diagram (30,000ft level) of all the things (entities/probable tables) that are involved. Also, you should create a list of conditions/business rules that apply to the "things" involved. You may also find the "stump the model" approach to be extremely helpful in adding details to your evolving model.

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

Similar Threads

  1. Need help with organization Newbie
    By dan@goditmaderanch.com in forum Access
    Replies: 5
    Last Post: 12-05-2016, 11:58 AM
  2. Data Organization - Tables-Queries Set Up
    By Roy Hobbs in forum Database Design
    Replies: 1
    Last Post: 03-04-2016, 06:52 PM
  3. Replies: 2
    Last Post: 07-24-2013, 01:29 PM
  4. Relationships/Data Organization
    By mixfeat in forum Access
    Replies: 2
    Last Post: 03-28-2011, 03:55 PM
  5. Organization help needed
    By Logan in forum Database Design
    Replies: 2
    Last Post: 07-30-2010, 11:00 AM

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