Possible to carry forward information from one record to the next? [message #442964] |
Thu, 11 February 2010 12:55  |
nik0lla
Messages: 17 Registered: February 2010 Location: Canada
|
Junior Member |
|
|
Hi all,
What I'm pretty much dealing with:
It's a checklist for canisters when they have maintenance performed on them. A work order is created, a canister is selected for the work order and the type of evaluation is selected (eg: Overhaul and Repair, Minor Repair etc). The checklist has many items to it and the one I'm primarily focusing on is the "Actuator Manufacturer". This field allows you to check off 1 of 3 choices of manufacturers and then a text box opens up on the side to enter the serial number.
What my boss wants:
He wants to have the value from this field from the last work order created prior to this one to carry forward. That means the manufacturer that they chose from the check boxes and the text from the text box, with the option of changing the information if it doesn't apply anymore.
My Question:
Is this even possible? I don't think it is but I thought I would run it past people with more SQL/Oracle experience than myself.
Thanks a bunch guys.
|
|
|
|
Re: Possible to carry forward information from one record to the next? [message #442967 is a reply to message #442965] |
Thu, 11 February 2010 13:28   |
nik0lla
Messages: 17 Registered: February 2010 Location: Canada
|
Junior Member |
|
|
That would work in some cases but I don't think so here.
How this database was created was the table has "cl_desc", "cl_completed" and "cl_comment". The cl_desc is the name of the item in the checklist, so it could be actuator manufacturer, but it could also be current status, canister SIN, etc etc. The cl_comment is the information from the text box, and the cl_completed is the initial of the manufacturer they had chosen. I guess I should have given more detail the first time around, sorry.
|
|
|
|
|
|
|
|
|
|