OK a attempt to more detailed description Open the database with access with suffix .fdb Open table tblAR = Addresses Column 1 "IDAR" is record ID Column 2 "Kind" have code 0 for personal address, 1 for eventaddress and 2 for archiveaddress. Find your imported marrigeaddresses with code 1 and change them to code 0 but make a note of the IDAR
- Here you found the IDAR 214-300 Open table tblIR = Individuals Column 25? "IDAR" is recordnumber for indivisual address. By putting an ID from tblAR here you connect the individual with the address. Change the 0 (zero) to the address record ID. - Do a search for the indivudal you want to connect to an event. Lets say you want to connect John Doe to event 214. Search for John and when you find the record go to column IDAR in his record and enter 214. Now event 214 is connected to John Doe. Repeat for all persons that should be connected to the events 214-300. Open table tblER = Events Column 12 "IDAR" is the events address record ID. Find the ID for the addresses you gave to individual and change to 0 (zero) thereby disconnecting the address from the marriageevent. Christer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kaufmann Sent: den 10 januari 2005 13:27 To: [email protected] Subject: Re: [LegacyUG] Print Marriage Address OK to tblIR step. Then confused. "By putting an ID from tblAR here you connect.....Change the 0 to the address record ID." My changes are for IDAR 214 to IDAR 300. Seems I can not do as block, rather individually - is this correct? What is an ID as there is not one in tblAR - or is it called something else? Many thanks for your suggestion Hope you can clarify above for me Jack ----- Original Message ----- From: "Christer Siverud" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 03, 2005 2:19 PM Subject: RE: [LegacyUG] Print Marriage Address >> Hi >> >> This is what to do but MAKE BACKUP FIRST !!! You are changing links > between >> tables and might lose information !!! Do not blame me if that happens. >> >> Open the database with access with suffix .fdb >> Open table tblAR = Addresses >> Column 1 "IDAR" is record ID >> Column 2 "Kind" have code 0 for personal address, 1 for eventaddress and >> 2 >> for archiveaddress. >> Find your imported marrigeaddresses with code 1 and change them to code 0 >> but make a note of the IDAR >> Open table tblIR = Individuals >> Column 25? "IDAR" is recordnumber for indivisual address. By putting an >> ID >> from tblAR here you connect the individual with the address. Change the 0 >> (zero) to the address record ID. >> Open table tblER = Events >> Column 12 "IDAR" is the events address record ID. >> Find the ID for the addresses you gave to individual and change to 0 > (zero) >> thereby disconnecting the address from the marriageevent. >> >> Good luck and be careful ! >> >> Christer >> > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John > Kaufmann > Sent: den 2 januari 2005 17:37 > To: [email protected] > Subject: Re: [LegacyUG] Print Marriage Address > > > Perhaps I am not clearly stating what I need. > > I have quite a few Marriage Addresses that are NOT Marriage Addresses - > they > were my mailing list from the Generations program. I want to translate > them > to the familly person for each family. No suggestions to date allow me to > do > this simply. I do not know all the people to create a tag for sorting. > >>From the print out, I will retype the addresses into the correct location. > > I have asked several times of Legecy on how to change the database fields > (I > am proficient in MS-Access), but have gotten no response!!! > > Hope this clarifies my need. > > Many thanks for your help...Jack > > ----- Original Message ----- > From: "Paula Ryburn" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Friday, December 31, 2004 12:29 PM > Subject: Re: [LegacyUG] Print Marriage Address > > >> Master Lists > Address Lists > Mailing: Tag the marriage addresses you >> want >> to print (e.g., churches) >> >> Reports > Address Labels > Who to Print: Event Addresses and check >> "Include >> only tagged addresses" >> >> Of course, pick label size, sort, etc. I think that should work for you. >> >> --Paula >> >> >> >> >> on labels >> >> thx >> >> >> >>> On labels? In reports? >>> >>> --Paula >>> >>> >>> >>> How to do this? >>> >>> Jack >> >> >> Legacy User Group Etiquette 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 > > Legacy User Group Etiquette 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 > > > Legacy User Group Etiquette 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 Legacy User Group Etiquette 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 Legacy User Group Etiquette 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
