Hello Mike Many Thanks for the information. All done and dusted Regards Reg Bellman ----- Original Message ----- From: "Beryl & Mike Tate" <post@tatewise.co.uk> To: <family-historian-users@rootsweb.com> Sent: Friday, January 06, 2012 10:52 PM Subject: Re: [FHU] Multimedia Links > Yes - after a little experimentation the following scenario applies. > > Link any Multimedia to another Record and open the Edit Media Item window. > Use the Link to Face option, or tick any radio button Exclude from > Diagrams, Exclude from Reports, or Use Note as caption. > Sometime later, Delete this other Record without unlinking the Multimedia. > This leaves behind Link/Note entries not linked to anything. > > To delete these en masse requires a Query so that you can select multiple > Link/Note fields and delete them. > > You need to create a Query Type of Multimedia and add Columns for each > Link/Note > %OBJE.NOTE2[1]% > %OBJE.NOTE2[2]% > %OBJE.NOTE2[3]% > etc up to say > %OBJE.NOTE2[20]% > > The Rows Filters need to be > Add if =FieldText(%OBJE%,'OBJE.NOTE2[1]') matches '""' > Add if =FieldText(%OBJE%,'OBJE.NOTE2[2]') matches '""' > Add if =FieldText(%OBJE%,'OBJE.NOTE2[3]') matches '""' > etc up to say > Add if =FieldText(%OBJE%,'OBJE.NOTE2[20]') matches '""' > [The value field is entered as two double quotes to represent the empty > string and becomes enclosed in a pair of single quotes in > the Rows Filter] > > In the Result Set click on a Link/Note column header to bring all empty "" > fields to the top so they can be selected and deleted. > Repeat this for each Result Set column. > > Regards, Mike Tate > > -----Original Message----- > From: family-historian-users-bounces@rootsweb.com > [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Reginald > Bellman > Sent: 06 January 2012 11:46 > To: family-historian-users@rootsweb.com > Subject: Re: [FHU] Multimedia Links > > Hello Mike > > Thanks for replying. > > I had look in View > Record Links and when I click on a media item I get > the > following:- > > Format > Title > Note > File > Date > Keywords > Link/note > all with information in, but then further Link/notes with "" only in the > Record ID column > > Do you have any idea what causes this? > > Regards > > Reg Bellman > ----- Original Message ----- > From: "Beryl & Mike Tate" <post@tatewise.co.uk> > To: <family-historian-users@rootsweb.com> > Sent: Thursday, January 05, 2012 9:25 PM > Subject: Re: [FHU] Multimedia Links > > >>I would advise NOT to delete these Link/Notes. >> On closer inspection you should find they relate to each Source (or other >> Record) that links to the Multimedia Record. >> Try holding Alt key and double-click on the Multimedia Record to fully >> expand it, and you should see each Link/Note is different. >> While it is selected use View > Record Links and all the Records that >> link >> to this Multimedia should be listed. >> The Link/Notes list should be the same or a subset of this Record Links >> list. >> >> Regards, Mike Tate >> >> -----Original Message----- >> From: family-historian-users-bounces@rootsweb.com >> [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of >> Reginald >> Bellman >> Sent: 05 January 2012 19:45 >> To: family-historian-users@rootsweb.com >> Subject: [FHU] Multimedia Links >> >> Hello All >> >> Happy New year to all. >> >> I am sorting out my media files and have notice that some of my media in >> the "Linked Records & Notes", the Linked Record List, have >> a tab in Pink/Mauve the wording Link/Note. Some of my media have one or >> two, but others have 24 all the same. >> >> I have tried to delete them as they do not seem to be attached to >> anything, but I can only delete them one at a time. Does anybody >> have this situation and has managed to work out if you can do a blanket >> delete? >> >> I have been using FH since Ver 2 and are now on Ver 4.1. 3. with XP home >> operating system. >> >> Regards >> >> Reg bellman >> >> ------------------------------- >> To unsubscribe from the list, please send an email to >> FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' >> without the quotes in the subject and the body of the message >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to >> FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' >> without the quotes in the subject and the body of the message >> > > > > ------------------------------- > To unsubscribe from the list, please send an email to > FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' > without the quotes in the subject and the body of the message > > > ------------------------------- > To unsubscribe from the list, please send an email to > FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' > without the quotes in the subject and the body of the message >