July 21, 200322 yr I am trying to use a calculation field (currently no stored, but tried both ways) as one end of a relationship with a second database. The relationship is on a unique ID to populate the portal. The calculation field works fine and constantly changes as you click onm different records in a repeating field. The problem is that the relationship does not seem to work as the field in the portal does not change to follow the calculation field. Any ideas???
July 21, 200322 yr Hi, First, check these 2 common mistakes. Your fields aren't set to use the same relationship as the portal. Your portal doesn't use the good relationship.
July 22, 200322 yr Also check that the data type of the calculation is the same as the key field in the related file (ie, not text one side and number the other).
Create an account or sign in to comment