Results 1 to 2 of 2
  1. #1
    dixiedork is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2013
    Posts
    1

    Individuals, Companies, Agencies, etc. into One "Entity" ...?

    I'mtrying to build a database that most accurately tracks county records and theparties involved with each. Every recordhas a Grantor & Grantee field, both of which can be one or several parties,and these parties could be individuals, married couples, companies (which, inturn, are represented by individuals of varying title/position), governmentagencies (also represented by individuals), Trusts (naming one or moreindividuals), a group of heirs (one or more individuals), etc. How do I go about designing the tables toproperly represent these entities and their respective representatives? Is it possible to have separate tables forIndividuals, Companies, Government Agencies, Trusts/Heirs, etc. and haveanother table/field that collects all ofthe above into an "Entity"? Iknow what I'm trying to do must have been done a million times before…

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    You might contact some other county governments and see how they manage the same type of data.

    What is nature of this data - monetary grants? I presume this is many-to-many relationship (each grant has multiple grantees and each grantee can be associated with multiple grants also each grantor can have multiple grants although each grant has only one grantor?). This could get complicated. I think the confusion arises from determining where address info should go. Consider:

    tblOrgs
    OrgID
    OrgName
    OrgType (company, agency, trust)
    Phone
    Address
    City
    State
    Zip

    tblEntities
    EntityID
    EntityType (self, representative)
    OrgID (leave null for individuals?)
    LastName
    FirstName
    Phone
    Address
    City
    State
    Zip

    tblGrants
    GrantID
    GrantSource (could be ID from tblOrgs)

    tblGrantees
    GrantID
    EntityID
    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. Replies: 1
    Last Post: 01-05-2013, 10:46 PM
  2. Replies: 2
    Last Post: 11-14-2012, 04:47 PM
  3. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  4. Replies: 11
    Last Post: 03-29-2012, 02:32 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