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…