AnsweredAssumed Answered

Relationship problem

Question asked by BobSchwenkler on Jun 16, 2010
Latest reply on Jun 16, 2010 by philmodjunk

Title

Relationship problem

Post

I have a match between two tables, let's say A and B. The layout is based upon A. B is viewed from a portal. Match field for A is a global calculation storing the number 1. Match field for B is an unstored calculation, calculating to 0 or 1. Both calculation fields are calculating to number. This match isn't working for me, no information displayed in the portal.

 

Changing Bs match field to a number field, the relationship works fine.

 

Bs field is calculating based on a condition set in table A. I could run a more involved script to set the fields in table B when this condition changes, but if I can just do it with a relationship that would be nice.

 

Seems like this is one of the relational idiosyncracies of this application, and I'm still learning them.

 

 

Outcomes