Discussions

Expand all | Collapse all

field name showing in related drop down field

  • 1.  field name showing in related drop down field

    Posted 07-17-2018 13:20
    I created a table for my list of departments and related that table back to my User Data table. When I go into my User Data form and select a department from the drop-down it has the name of the related field and the record # included. How can I get the drop-down to just show the department and not all the other stuff?
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1741256/RackMultipart20180717-79910-u7qyeh-Dept_field_inline.png?1531833521">
    I want to get rid of 'Department or Group #7 -'  and just keep 'CCBSS - IT'Thank you


  • 2.  RE: field name showing in related drop down field

    Posted 07-17-2018 13:32
    This is coming from your record picker. Go into your form properties, Highlight the related field. You will see in the pane to the right "When Used for Data Entry". It will have selected "Use the standard record picker". Click the "report" link beneath that. This will take you to the record picker properties. Remove the offending field from the record picker list.


  • 3.  RE: field name showing in related drop down field

    Posted 07-17-2018 13:42
    This worked. Thanks.


  • 4.  RE: field name showing in related drop down field

    Posted 07-17-2018 13:32
    The low tech solution is to adjust the Record Picker fields for the table from which you are picking records.  The Record Picker fields are the fields shown to users to help them "pick records" from a drop down list.

    You access the Record Picker settings off the Settings for the Table and then Advanced Properties.