Gary, When I first read your inquiry and saw your name I thought I might have been writing to myself! I have a similar issue.
I've kept an Access database of scraps of source(s) information for years...long before I switched to Legacy. One of the reasons I switched to Legacy was that it was better at presentation of my genealogy information AND retained my ID#'s when I imported the GEDCOM file from my old program. This was of PRIME concern since my Access DB is maintained for information based on the ID#. I presently have close to 3,000 bits and pieces of information entered from Internet sources, books, obituaries, newspaper entries, wills, war records etc. My problem (dilemma?) is that I have all this source information in an axillary database but as far as my knowledge is concerned no way of getting it into NOTES in the individuals ID# in Legacy short of transcribing it by hand....which I'm not about to do - given the amount of duplicate work that would cause. In addition to the ID# in the Access database each record has a unique Reference number (0001-2875). To illustrate, ID# for ancestor great-grandfather Jacob Killbottom Legacy ID# 193 and ID# 193 in the Access database has reference numbers 0017, 0989, 1712, 2276, and 2301 of various pieces of information I've found for Jacob Killbottom. What I'd like to know is if there's some way of *linking* the Legacy ID# with the ID# in my Access database. I've given much thought to my dilemma over the years and have yet to come up with a practical answer. Gary Crull On Sat, 4 Feb 2006 23:35:16 -0600 "Olds-Wills-Hodges-Harris" <[EMAIL PROTECTED]> writes: > I just picked up MS-Access 2003 with the intent of using it to create > indexes of my files. I have 8 file categories: newspaper clippings, > photographs, documents, voice/video recordings, correspondence, > city directories, census extracts, heirlooms. > > Each category has a unique file number prefix and each item in every > category is assigned a file number. For instance, I have photographs > numbering from P-0001 to P-0847; I have newspaper clippings numbering > from N-0001 to N-0985; I have documents numbering from D-0001 to > D-0770; and so on. > > Does anyone know if there is anything available from Legacy or elsewhere > that explains how/where certain elements of data can be located in the > Legacy database using MS-Access? For instance, I would like to extract > from Legacy the RIN, First Name/MI, Last Name, Married Name, and > User ID to read into the database I'm creating for the various file categories. > I have used ASCII before when transferring data between programs but > needed to know field sizes and so forth, I "think" I would need similar > field size and location information from Legacy to accomplish my intent. > > It appears as if Legacy has data segmented into a collection of tables. > Is there a description available that explains the type of data each table contains? > > If there is anyone on the list who has created or is using a similar > database system for their files I'd like to hear from you. > > Thanks > Gary Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter online at http://legacyfamilytree.com/FreeTrip.asp Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
