AnsweredAssumed Answered

Want to confirm: is calculation field cant be used to relate tables?

Question asked by TaylorJansen on Aug 24, 2013
Latest reply on Aug 28, 2013 by philmodjunk

Title

Want to confirm: is calculation field cant be used to relate tables?

Post

     In Table A I have a calculation field to calculate the status of the record, the result is a text field. The result maybe either Complete of Incomplete

     In Table B i have an auto-entered field which enter Incomplete to the field. 

     These to fields are linked so that a portal in a layout based on Table B would show records from Table A with status Incomplete.  But it is not working. If I change the relation to relate not a calculation field, the portal works.  is it becasue calculation field cant be used to relate tables?

      

Outcomes