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!