On 12/5/2012 5:18 AM, Ian Goddard wrote: > I'd hoped to get some specific ideas to compare with my own idea about > data structure which is: > > Data types > > Person: > Surname : string > Forenames : list of string (probably implement in Free Pascal so that > would be TStringList) > Qualification : string (e.g. Executors of) Isn't this really a case of a many-to-many relationship? A person can own (for example) many parcels, and a parcel can have many joint owners. So shouldn't the Qualification field be in the table that links the land to the person? > PersonList : list of Name > > StatuteMeasure > Acres : smallint > Roods : smallint > Perches : smallint > > OldMoney > Pounds : smallint > Shillings : smallint > Pence : smallint (assumes that further investigation doesn't reveal > ha'pence or farthings!) Perhaps store the amount as a number of farthings, so that the database does not need to be changed if you find some recorded that way. The user interface could take care of converting back and forth. The same could be done with the size above. -- T.M. Sommers -- ab2sb