Want to confirm: is calculation field cant be used to relate tables?
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?