Forms and tables

[phoenix]

I'm trying to design a database and have some basic questions.

The order table has five fields - WO number, customer ID, due date and part number and status - (Could be any of 4 values - Received, warehouse, in-process, shipped).



I only want the status to be updated by the operators. But in order to do so he needs to see the first two fields. The status is updated 3 times a day.

Could I use a form which would be used to update the status and then use it to populate the master schedule?

Any ideas which I could use to design this database?

[NTC]

your question does not really make it clear why a traditional form/table would not work.....so explain why a form sourced on a table is not suitable....