Order progression

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi there

I have a database and wish to update a customer order
form with a field for order progression details.

I need to have a block i can put a date/time, intials of
operator and an order progression details. Ideally i
would like to be able to be able to add mulitple
progressions to an order and have a seperate line for
each one, with the most recent progression at the top.

Hope that makes sense, Any help would be appriciated,
Thanks
Steve
 
Steve,

I assume you have already an Order table or some such, with fieilds
something like:
OrderID
CustomerID
OrderDate

You need to have another table now, let's say you call it
OrderProgressions, with fields like this...
ProgressionID
OrderID
ProgressionDateTime
Operator
ProgressionDetails

Then, you can make a continuous view form based on this table, and place
it on your Order form as a subform. That should provide the required
functionality.
 
Back
Top