Not reading related table fields where the related table field is a derived from a drop-down list
Operating system version
Mavericks OSX 10.9.1
Description of the issue
Building first database into day 10 and doing very well. If I have two tables
Table A Table B
Table A) Normal edit Field.............. Table B) Field with Drop-down menu
Table A edit field is set to read Table B field with drop down menu
Table A does not read any field in Table B where a drop down menu has been used to enter a value.
Values in the drop-down menu are all text and correct.
I feel there is a bug in the drop-down field option preventing them to be read properly.
Steps to reproduce the problem
Table A is related to table B
Table A successfully reads edit fields from Table B
Table A field correctly is set to navigate to the correct Table B field
Nothing is showing in Table A field, even though Table B field is set to be read from Table A field
Table B drop-down field selection to display in Table A edit field.
Table A blank field
Exact text of any error message(s) that appear
One database with five related Tables. Table A is directly related to Table B and already correctly extracts information but only from Table B normal edit fields.
None yet. (Unusual for me!)