December 16, 200817 yr 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
December 17, 200817 yr "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.
Create an account or sign in to comment