Added a reference field to form through Form Design - but field record picker displays no values

[ServiceLater1]

Hi there, I am working on updating the design of a form in a custom table, let's call the table u_order_requests.

Using Configure > Form Design I added a reference field to table ast_contract the field is called "contract".

Show "contract" displays:

u_order_requests.contract:
Table:task
Field: contract
Type: reference
Reference: ast_contract
Attributes:
edge_encryption_enabled=true,​
encode_utf8=false,
​readonly_clickthrough=true,​
ref_ac_columns=short_description,
ref_auto_completer=AJAXTableCompleter

In the table ast_contract there are many records.

However in our custom table u_order_requests, in the form, when I click on the contract field the record picker which pops up shows no records.

What could the reason for this be? I am admin and have all required roles.

[Michael Jones - · Accepted solution]

Most likely the issue is the reference qualifier for the field - your table is extended from task I assume?

You probably need to create a dictionary override for your table - you can try it would by creating the over ride, checking the box to override the reference qualifier and leaving the field blank and see what your results are. 

I hope this helps!

If this was helpful, or correct, please be kind and mark the answer appropriately.

Michael Jones - Proud member of the GlideFast Consulting Team!

[ServiceLater1]

Thank you, that was it.