Suppose I have a hypothetical application w/ two tables:
- OrderInformation - contains information regarding an order, like customer information, salesperson information, etc...
- OrderDetail - 0 or more records would be assoicated with a record in OrderInformation. Each record in this table would represent a specific order line item.
What I would like to do is as follows:
-Allow a sales person to login in.
-Allow a sales person to be able to pull up a list of all of their orders (display list of entries in OrderInformation, for the sales person logged in)
-From this list, allow a sales person to view/edit an order. This would present:
- a form with specific fields from OrderInformation, followed by
- a list of 0 or more records from OrderDetail, associated with the order being viewed/editied
- OrderDetail records could be added/deleted/edited
For example
List of orders:
Order Number Customer Name Sales Person Name Date
3123-12 Joe Schmoe Jim Schmoe 2/24/2003
3123-13 Jane Schmoe Jack Schmoe 2/24/2003
If Order Number 3123-12 is selected:
Order Number: 3123-12 Customer: Joe Schmoe
Date: 2/24/2003 Salesperson: Jom Schmoe
Customer address: 123 Main Street
Anywhere, AW 0000
Item Description Unit Price
1 Blah 1.00
2 Blah 1.00
3 Blah 1.00
Can this be done with ASPRunner?
Thanks!