Skip to main content
Question

Can I change the Relationship selections in a dropdown?

  • February 11, 2014
  • 0 replies
  • 42 views

I have created a relationship between 2 tables. The relationship is linked to a Provider's Name. However, when in the form, I click the dropdown and it shows "Provider #1 - Address of Provider." I'm wanting it to show the actual Provider's Name (i.e., Dr. John Doe). Is there a way to change what information is displayed in the dropdown?

This topic has been closed for replies.

The default fields offered on these type of drop downs are form the record picker fields which are set in the table properties for the table you are choosing records from. So one option is just to change those defau8lr record picker fields.

Another option is to make any report that you like with any filters and sorts that you like and edit the FORM (not field) properties for that drop down field to use the report for its display fields to aid you in choosing a record from the list.
Terms & ConditionsAccessibility statement