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

[dixiedork]

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…

[June7]

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