Peter
Many thx for your input
Cheers
Peter Cushing wrote:
Paul Newton wrote:
Peter
Tx for the mail. By all means let me have your ideas - on- or
off-line as you prefer.
Hi Paul,
Presumably you have some sort of file for each burial register entry
and therefore a PK entry. If you create a new file say "burialkeys"
or whatever and have structure:
RegisterPK - PK of the burial register
PhotoID - The unique file name of the photo C(10) or whatever.
Surname C(10) - Chop down to 10 chars
Year C(4) or N(4) if you like
Parish C(10) - again chop down to 10 chars
Extradata C(60)
Have an index on all fields.
The idea being to link all the words associated with a burial register
with a photo, so for example if you had description "John Smith buried
1990 in Boston - had a wooden leg" you could then go through the words
and pick out the surname, year and parish make an entry in the table.
To get the data into the system you can hopefully import it from your
spreadsheet or if you have a form that shows burial registers you
could put a command button on "Attach Image" and then when they pick
one get the words associated with the picture and put the record in
the table when you save. I would copy the photo to one folder when
you save.
When they want to do a search they could Smith in the surname box,
1920 in the From year box and 1922 in to to year box (which you can
use to generate a between clause). Then enter Erehwon in the parish
box and you could generate your sql select with where clause:
Surname="Smith" and between(year,"1920","1922") and parish="Erehwon"
Put all matches in a list and when they click on an item - show the
photo plus any description for the photo.
You could add the wooden leg to the extradata field and have an extra
search box where you could type in Wooden and do "Wooden" $ Extradata
on the end of you select.
Just a few ideas of the top of my head.
Peter
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
