1 Reply Latest reply on Mar 4, 2013 11:10 AM by philmodjunk

    Relationships in the ERD

    ahcho

      Title

      Relationships in the ERD

      Post

           Hello!

           I was wondering what the following symbol in the ERD stands for. Its a relationship between a regular field and calculation field but the relationship doesn't work. Why is that?

            

      Rel.jpg

        • 1. Re: Relationships in the ERD
          philmodjunk

               If you are talking about the vertical line in the lower match field, this field is apparently a global or unstored calculation field and cannot be used to match records in the type of relationship that you have here. (It won't have the required index so that individual records in the table shown can be matched to values in the defined match fields on the other side of the relationship.)