I thought these tables had gone. I don't have any in V8. Graham Sent from my iPad
> On 6 Feb 2014, at 07:20, Dave Scott <[email protected]> wrote: > > Hello All, > > I have resolved this issue. The User ID is stored in a field called UserRef > in the table tbIR. It was easy to create an update query to populate the > User ID field for all my records. > > Sorry to have bothered anyone. > > Dave > > > > > Begin forwarded message: > > From: Dave Scott <[email protected]> > Subject: Microsoft Query to set UserID's > Date: February 5, 2014 at 7:14:55 PM MST > To: [email protected] > > Hello, > I have just read the help file on Meaningful Picture Names. It mentions: > > "To quickly assign User ID numbers to the thousands of individuals in my > family file, I created an Update Query in Microsoft Access." > > > I have quickly looked at the tables and it appears that i need to relate the > IDIR field in the tbIR table to the IDIR field in the tbBR table then > calculate the FilingRef field in the tbBR based on the Surname and IDIR > fields from the tbIR table. > > I think the IDIR field contains the individual's RIN number and the FilingRef > contains the User ID string. Can anyone verify this for me and if possible > provide the SQL string for the Microsoft Access update query? > > Any help would be much appreciated. > > Dave > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on > our blog (http://news.LegacyFamilyTree.com). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
