I have two separate fields on the same table. One of them titled PM the other titled File Status. I want that when the PM box has an "x" in it, that it updates the File Status to read Status Complete or PM or Awesome. Please help
You could use one field formatted as a check box with "status complete" as the single value value list used to format the field.
Also as a follow up. I field that listed as PM is an imported field.
Do you mean the "x" is exactly a character imported?
You can make "File Status" field as calculation or auto-enter, like as
Case ( PM = "x" ; "Status Complete" )
Changing field definition can lose your data, so make back up before try.
Retrieving data ...