I have a customized work order view with the following fields: ID#, Title, Assigned To, Client, Status, Priority, Due Date, +8 other fields
When I got to Edit in Datasheet, the Client field doesn't show up even though the box for that field is checked off in my custom view. (Both the Assigned To and Client fields are lookup fields that go through a global employee directory)
The reason I Edit in Datasheet is because my work orders are often duplicates where only the Due Date needs changing, so rather than try to input all the fields, I copy and paste the record and just change the Due Date.
Why is this happening and how do I fix it?