Hello,

I'm attempting to create an Order Management application and would appreciate any direction in helping me to think about this in the right way.  This is what I'd like to do:

1) Import Order Number and related information via XLS file and automatically assign a "NEW" status to each of the records

2) Show "NEW" orders on a Home or Dashboard View with a click link to "Processing" Form that auto-fills the Order Number.  The "Processing" Form would have the auto-filled Order Number field and fields for Date, Supplier 1 #, Supplier 2 #, and on Submit, the Status of the order would change to "PROCESSING"

3) Show "PROCESSING" orders on a Home or Dashboard View with a click link to "Shipment" Form that auto-fills the Order Number.  The "Shipment" Form would have the auto-filled Order Number field and fields for Date, Supplier 1 Tracking #, Supplier 2 Tracking #, and on Submit, the Status of the order would change to "SHIPPED"

Eventually I'd like to build up the Home or Dashboard View with pretty graphs and Total Outstanding Orders for New, Processing and Shipped orders but that can come later.

Again, I appreciate any direction on this one.

Thanks,

Brian