Qrew LegendThis should be an easy fix. Look at the form properties for that drop down field and if the from is set to use the default record picker, go to the Advanced Properties for the table and set the correct record picker fields to use useful to your users. If the drop down is driven by a report, make a report with the correct fields and sort and set the form to use that report for the user to select a record.
OK, forgive me for still being a little new and only knowledgeable enough to be dangerous...I don't want it to be a record picker or drop down at all. I just want it to display the information that came in from the update. The user should only edit this field in the rarest of circumstances. Also, this is a problem across multiple reports that are unrelated to the HVNE PO's function. None of the users should have any edit power on the field EXCEPT when updating the table as a whole as part of a daily information load in a table to table update.
