14 Replies Latest reply on Mar 25, 2016 12:42 PM by tomperr

    Simple relationships can not be established?

    tomperr

      I seem to be running out of options to resolve what I think should be a very simple solution.  I am attempting to create a relationship between 2 tables in order to create a portal to show a list of records.

      Set is as follows:

      Table A has 4 fields with 1 record.

      Table B has 12 fields with 31 records.

      The relationship field would be 1 to many. 

      The 2 fields used in relationship are:

                Table A field 1 is set up as a calculation "Get(AccountName)" with Text Result. Global Storage has been selected here. 

                Table B field 1 is set up as text.

      When assigning relationship  thru relationship tab, result show 1 to many representation.

      When adding fields to the form Specified Field shows the individual tables and Related Table shows <none>.

      Why cant the relationship be established?  I tried adding # fields to form relationship with both identified as #s, but results are the same.

      Resolution to this problem will be greatly appreciated!