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]