> 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
