LineNum Issue Through DTW

[#1]

Hi Experts,

Im having Issue With LineNum.....

I Have added one record into udo(Master type) through dtw like this....

Child table sample data

ParentKey LineNum   U_RATE         U_frmdate

Code         LineNum   U_RATE         U_frmdate

SH033              0          10                2013-07-19

SH033              1          10                2013-07-19

Upto Her Its Working Fine....

but

After Adding the Data im updating the same by adding one more record through dtw like this

ParentKey LineNum   U_RATE         U_frmdate

Code         LineNum   U_RATE         U_frmdate

SH033              0          10                2013-07-19

SH033              1          10                2013-07-19

SH033              2          10                2013-07-19

After This

In ChileTable LineNum is Changing to 3,4,5 ........

But I want 0,1,2........

How To Solve This Issue

Any Help Would Be Greatly Appreciated

Thanks

Shafi

[KennedyT21]

Please close your thread by marking helpful/correct answer.

Thanks,

Kennedy

[Former Member]

Hi Shafi,

In your case, you just need to add one record. No need update.

Thanks,

Gordon

[KennedyT21]

Hi Shafi,

Why you need 0,1,2 as, the set of records you have provide its correct 3,4,5.

If you change the Parent key only you will get the desired result what you looking for.

Regards

Kennedy

[Former Member]

Hi Kennedy,

Thanks For Your Reply

because im using this table in the addon

Im doing this manually

i have already two records in the child table(udo of master type) with lineid 1,2 . Now im adding the thrid record and click on update button then its giving me the lineid as 3 . Its ok

but when i try the same through dtw its chaning and giving me the lineid as 3,4,5

Any Solutions

Thanks

Shafi

[KennedyT21]

Hi Shafi,

Can u post your screen for better understand.

Have u checked with the records in the backend.

Regards

Kennedy

[Former Member]

Hi Kennedy,

My First Image is When i added Records (In Dtw I have selected the option as "Add New Reocrd")

My Second Image is When im updating the records(In Dtw I have selected the option as "Update

Reocrd")

Thanks

Shafi

[KennedyT21]

Hi Shafi,

Have you mapped with the correct fields at the time of DTW.

Regards

Kennedy

[KennedyT21]

Hi Shafi,

I have a doubt

Does you Child Table is Master Data Rows Or master Data.

Regards

Kennedy

[Former Member]

Hi Kennedy

Thanks For ur Reply

I Have Mapped the data with the correct fields.Data is inserting correctly but lineids as changing when updating the records

My child table is master data rows

Any Suggestions Experts

Thanks

Shafi