Search technique question

[JerryG]

Does anyone have an idea on how to accomplish what I need in a special search? Let's assume that in File "2" I have 4 repeating Fields: A, B, C, D, each with 10 repetitions. From File 1 I want to look at a given record in File 2 and search Field A repeating fields for a particular phrase such as "a1". If "a1" is found among the repeating records of Field A I then want to copy back the respective records from Fields B, C, and D into a set of fields in File 1. For example, if I find the code "a1" in the 7th repeating field of Field A then I want to copy the 7th repeating field of Field B to a specified field in File 1, the 7th record of repeating Field C...etc.

Thanks,

JerryG

[Chuck]

quote:

---

Originally posted by JerryG:

Does anyone have an idea on how to accomplish what I need in a special search? Let's assume that in File "2" I have 4 repeating Fields: A, B, C, D, each with 10 repetitions. From File 1 I want to look at a given record in File 2 and search Field A repeating fields for a particular phrase such as "a1". If "a1" is found among the repeating records of Field A I then want to copy back the respective records from Fields B, C, and D into a set of fields in File 1. For example, if I find the code "a1" in the 7th repeating field of Field A then I want to copy the 7th repeating field of Field B to a specified field in File 1, the 7th record of repeating Field C...etc.

Thanks,

JerryG

---

Check out www.databasepros.com and go to the resources section and search for "repeating". There are a number of files there which if you take apart can help you solve this problem.

Chuck