Relationship problem using repetitions

[Kurt Knippel]

quote:

---

Originally posted by Jeff Abraham:

I have an employee database that is related to a customer profile database. In the profile database the related field (employee name with 25 repetitions) is based on values in the name field (1 repetition) of the employee database. I want users to select an employee name in the profile database and have all of their employee information automatically added to the profile database. This works great for the first repetition but it does not find the data for any other repetition. Any help would be greatly appreciated! Thanks!

---

Repeating fields do NOT work with relationships. Only the first value is indexed and used.

Break your repeating data into a seperate related file.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[Jeff Abraham]

I have an employee database that is related to a customer profile database. In the profile database the related field (employee name with 25 repetitions) is based on values in the name field (1 repetition) of the employee database. I want users to select an employee name in the profile database and have all of their employee information automatically added to the profile database. This works great for the first repetition but it does not find the data for any other repetition. Any help would be greatly appreciated! Thanks!

[Jeff Abraham]

Thanks for the reply. After I posted my problem I changed the repeating field to a portal and everything is working great. Your reply confirms that repeating fields do not get the job done most of the time!

Jeff