I have a FM database with text field that has 200 repetitions. This lists the contents of book and magazine articles in my collection. Whenever I do a find for a specific set of text, it's an exercise in total frustration to locate the exact occurence of the found text. There used to be a script, called Hilight, or the like around that tried to accomplish this task, but I could never get it to work on repeating fields and now I can even locate it. All the url's are broken.

This is an egregious oversite for FM not to implement. Any thoughts, ideas, workarounds?

Thanks in advance.

J.D. Thomas

ThomaStudios

[email protected]

The biggest problem you are having is using a repeating text field. If you used a related structure instead of a repeating field, the problem with locating the repeat of the repeating field on which the text appears would go away. A find in the related structure would find the RECORD in the related file in which the match occurred. One more strike against repeating fields.

-bd

I'm not entirely sure how I could convert to a related structure. The current file has over 500 records, each record has a minimum of 40 or so entries in the aforementioned repeating field. Does this mean each of those entries needs to be a separate record, set up with a relationship?

Can you provide me with more directive here?

Thanks.

So that's it? You're just going to leave me hanging, not giving any more info as to how I can recitify this situation?

Great.

Real informative list here.

if you do a scripted find, where is the problem? Just make a repeated calc field, mark_finds

mark_finds=if(patterncound(myfield,Extend(g_findwhat))>0,"look here","").

Can I suggest you start by reading about FMP's relational capabilities in the online help or the manual? If you have absolutely no idea about relational databases, look for a training course that you can attend.

Also, be patient when posting a question. Some people don't check the forums as regularly as others. However, there are some geniuses on these forums who are very forthcoming with the best tips & solutions to be found anywhere!

Remember, people here are giving assistance in their own time and without reward (apart from that warm, inner glow). Your comment above is hardly likely to encourage others to help you.

cheers,

wendy

So that's it? You're just going to leave me hanging, not giving any more info as to how I can recitify this situation?

Great.

Real informative list here.

I was just about to suggest something and then I've read this

Why don't you RTFM?

The idea of the forum is for people to help you, give you advice and point you in the correct direction, not to write your solutions for you.

As Wendy pointed out, the experts on this forum - and there are some great ones - do not get paid for the help they give, they do this out of generosity.

May I suggest you pay a bit more respect to those trying to help you?

"Real informative list here."

Well yes it is, I have learnt so much from the help that users of this forum have given me, try browsing round the forum a bit, and this will give you an idea of the expertise that lies here.

I am always grateful to the members who help me, no matter how much or how little help they have given me, 1 reply to a question is 1 step closer to solving your problem even if it is not the complete answer.

With comments like yours, you'd be lucky to receive any reply, never mind a reply that will actually solve your problem.

Maybe you should take these comments and those of the users who have posted above and change your attitude to the other users. If not, I don't think this forum is going to be of much help to you.

Regards

Ed.