Find repetition that matches find criteria

[eljefejb]

Hi,

In the hope that there are no stupid questions...

How can I determine the repetition number of the field which matched criteria entered in Find mode? Since Find returns records which have a field whose contents match the criteria, and not the field itself... and if the matching field is a repeating field, and the matched criteria is only contained in a specific repetition of that field. Confusing!

Some context for you: I'm building a "work journal" solution, wherein the records simply store the username, date, and a repeating field of tasks accomplished by the user on that particular date. I would like to add a search box to the UI. When doing a find, you get back a set of records (journal dates). I have 20 numbered layouts which "expose" the repetitions of the tasks field one at a time (depending on how many contain data). I need to determine which repetion of the tasks field matched the Find criteria, so that I can switch to the proper layout number which exposes that repetition.

Thanks in advance... hope my explanation didn't just confuse you. :B

[Vaughan]

"I'm building a "work journal" solution, wherein the records simply store the username, date, and a repeating field of tasks accomplished by the user on that particular date."

Forget repeating fields for this and use a related table to store the tasks, and a portal to display them.