On Fri, 24 Jun 2011 15:22:51 +1000, Robert G Eldridge <[email protected]> wrote: >On Thu, 09 Jun 2011 12:58:54 +0200, Steve Hayes ><[email protected]> wrote: > >>I am thinking of creating a database for people to record strays on these >>sites, and thought I would ask for advice on what to include in such a >>database, especially from those who may have had some experience of strays >>indexes. >> >>The Yahoogroups databases are limited to 10 fields, so one needs to give some >>thought to what should go in them. I am thinking of the following: >> >>1. Name of the principal person (Surname, Firstnames) >>2. Date (of record or event, in YYYY-MM-DD format) >>3. Place (of record or event) >>5. Place of origin of the person (if mentioned) >>6. Relations of the person (if mentioned) >>7. Source (newspaper, tombstone, church record etc.) >>8. Notes (any other information about the person or record) >>9. Informant (name of person who entered record, and contact info) >>10. Date record entered. > >On reading this initially my first thought was that possibly 6. and 8. >could be included in the one field (8.) leaving a spare, for use as; > >6. Nature of event - Birth/baptism, Marriage, Death/burial or Other. >This would facilitate an only B or M or D or O data input being >allowed and allow a degree of sorting if needed, thoubh it could be covered by 8. Thanks, that's useful and bears thinking about. I'm not sure that it would need to be sorted on, but -- Steve Hayes from Tshwane, South Africa Web: http://hayesfam.bravehost.com/stevesig.htm Blog: http://methodius.blogspot.com E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk