I have a master / detail table, however I’m trying to apply a sequence to the detail section.
Master table contains
M_ID, DATE, PER_ID
1, 01-May-15, 1
2, 01-May-15, 2
D_ID, M_ID(FK), SEQ, ACCOUNT_ID, TASK_ID, HRS, TRAVEL_HRS
The sequence needs to increase each time a job is requested/created, however have the ability to change its order.
For Each job this must start from 1.
Once the SEQ is set. I will then need to go update all current records retrospectively .Hope this makes sense.