Hello,
I linked Table A.field5 to Table B. Table B contains several fields: field1, field2, field3, etc.
I changed Table B.field3 to make it the primary field and hid all the other fields. Unfortunately, in the dropdown menu for Table A.field5, all the fields from Table B still appear.
I also tried creating a view, but I get the same result.
My question is: is it possible to limit which fields from Table B are displayed in the dropdown?
Thank you for your help ( i am a beginner)