The reference field is not displaying the values from the table that I reference but it is displaying values from a choice from a differenct field on that table.

[helenscheck]

I have created 2 tables with the same field labeled Policy ID number.   Stage 1 Policy and Post Production Review, on the Post Production Review table I have the Policy ID Number field set up to reference the Stage 1 Policy Table w/Policy ID number as the field.

When the form is open it is displaying values that are from a Choice List that is in the Stage 1 Policy 'Agency' field.

I can't seem to get it to pull from the Policy ID Number field even though I have entries available on the table.

Any help would be appreciated!

[johnkitchen · Accepted solution]

Helen,

Have you looked at the configuration of the table you're referencing? Make sure the field you want to display in your reference variable is marked as "True" under "Display" on the table's configuration:

[helenscheck]

thanks, that fixed the issue!