Dennis et al - I don't know how to make it any plainer - I want to change the File Detail ID number from 1234-1 to 9876-01. I would like to use Access to enter 9876-01 in lieu of 12340-1 in the 'File Ref' field or whichever table this will work on. I woiuykld liek to do it this way so I can see if I covered all of the changes I need to make. My attempt to change it by opening one of my saved .fdb files in Access, then using the tblSX, making the changes and then when I exited Access and opened the .fdb file, the changes did not occur - so..... If this explanation doesn't cover it, I'll move on.
=I ---- Valerie Laskowski <lask...@att.net> wrote: > The "FilingRef" field is in BOTH tblSX and tblSR tables. Double check at > which level that you entered the text for "FileID". > > If you "Edit Master Source" and want it on that screen -- then use tblSR. > > If you "Edit Detail" and want it on that screen -- then use tblSX. > > Valerie > > -----Original Message----- > From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf > Of Dennis M. Kowallek > Sent: Friday, August 21, 2009 7:42 AM > To: LegacyUserGroup@legacyfamilytree.com > Subject: Re: [LegacyUG] Table Usage & Access > > On Fri, 21 Aug 2009 5:27:28 -0400, SgtBob <s...@cox.net> wrote: > > >A couple of suggestions I received indicated that I was on the right > tract that might permit me to change them in tblSX using Access - > unfortunately, I have discovered that even if I change the 'Filing REF' > data, the change doesn't 'take' in my 'bob.fdb' file when I re-opened it in > Legacy. > > Then my guess is that you updated the wrong row in tblSX. tblSX is a > tricky devil. See ... > > http://zippersoftware.com/ltools/help/v1/tblSX_Type.htm > > ... for more info on the tblSX.Type column and how it relates to > tblSX.IDIME. > > Since it appears that you may have updated the wrong rows, I hope you > restored your database back to where it was before you made the Access > updates. > > >Any suggestions on a method to do mass changes to Detail File ID's when in > Access? > > Sure. I can write a very simple UPDATE query that will change every File > ID in your database to "Fred Flintstone". But I don't think that's what > you want! > > Do you mean change every occurrence of "1234-5" to "9876-4"? Give us > some detailed requirements and we can tell you if it is possible. Lay it > out logically so we don't have to guess what you mean. > > -- > > Dennis Kowallek (LTools) > http://zippersoftware.com/ltools > http://groups.yahoo.com/group/ltools > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > -- /Users/robertrunion/Desktop/eMail Icons/signature.pdf Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp