1 Reply Latest reply on Oct 17, 2011 9:30 AM by philmodjunk

    lookup problems with repetition fields



      lookup problems with repetition fields


      I created 5 tables in one database.

      I created a relationship between two of them. student record and course record

      I created a lookup for a repetition filed. when i type in the course # in first row the name and level will show up.

      but if i Type in course #  on the second line noting will show up in name and level.

      where did i make the mistake?


        • 1. Re: lookup problems with repetition fields

          The mistake was to use repeating fields. This won't work, as you've discovered. While you could use a set of individual fields, it will be a much better database design that will work much more flexibly for you if you replace your repeating fields with a table of related records. The layout shown can easily be updated to use a portal in place of your three columns of repeating fields.