AnsweredAssumed Answered

Reasons why relationship is not working.

Question asked by alberto__1985 on Feb 15, 2015
Latest reply on Feb 18, 2015 by alberto__1985

My name is Alberto and I'm new to the forums so excuse me if I miss important information on my question.  I will try to be as accurate as possible.  Ok here it goes I have two tables joined via a relationship.  Table A (Records) and Table B (Forms).  The relationship is setup via a global field in Table A ( = field in Table B (  I have a button that performs a script that sets Field ( in Table A (Records) to the form name I want related info from.  Then the script goes to a layout based on Table A (Records).  At this point is where I can't figure out why if I place a field in the layout for I get the value set by the script but when I place a field for the field is blank along with any other fields from Table B.  I have checked the data on Table B and there is a value on = to the value being set by the script on just unsure why the relationship is not happening. Also is a calculated text field from 3 other text fields in Table B (Records) indexed minimal (as necessary) and as mentioned before is a global text field being set by the script.  Any ideas on what might be happening or where am I wrong or any steps that can be  taken to troubleshoot the issue?