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
_______________________________________________
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.
