This is not so much a Base question as a database application question, which I ask here only because the many Base users may be able to point me to a good reference for this common problem: When constructing a database of persons, where it is important to be able to have family-oriented reports, the variety of naming conventions can make names a source of problems beyond what is found in a typical Users&Groups type of database.

For example, ["First_name", "Last_name"] can be ambiguous fields because of the implicit Western convention of associating "Last_name" with "Family_name" or "Surname" - which many Asian names put first. Is it best to use fields ["Surname", "Given_name1", "Given_name2", ...] with a field "Preferred_name_order" to indicated Surname-first or Surname-last preference?

On the other hand, the ambiguous association of "Surname" with "Family_name" requires an independent Family table with a "Family-key" primary key field for use in a Person record. This is identical to the process with a Users&Groups database, but with this wrinkle: When building a Users&Groups database, the number of Groups is typically small and predictable, such that one can make mnemonic Group keys {ACC, ENG, MKT, ...}. With Persons&Families, the number of Families is large and unpredictable - yet it would be nice to have some similarly mnemonic keys. How can such keys be automatically generated? This is both a design problem - which must have been solved MANY times - and a Base implementation problem. Similarly, one would like to make a Person-key generated from some combination of Surname and Given_name fields - again, a problem which must have been solved many times. Can anyone point me to:
 (a) A database reference for Person/Family name considerations?
 (b) A Base implementation of automatically generated mnemonic keys?

And if, as I suspect, I'm just asking this in the wrong place, suggestions on where else to ask would also be welcome. Thanks,

John

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to