Inputsum doesn't work after joining to another table?

[#1]

I've created a NewField and used INPUTFIELD in my script in a new table using Inline so that the user can control the values within the NewField, and then I need to join this new field to a table I already have. Problem is when I drop the Temp inline table, then I won't be able to use Inputsum in the front end for the user to input the values in my NewField, not sure how I can fix this?

   MainTable is:

ID	Criteria	Step	Numbers per each step
2512	cri2	1	12
2874	cri3	2	11
3290	cri1	2	3
1249	cri1	3	4
2840	cri3	1	6
1295	cri2	1	7

And this is what I have, when I dont join, the Inputsum works, but after I join it doesnt.

INPUTFIELD NewField;

InputTable:

LOAD * INLINE [

     ID, NewField

    2512, 0

    2874, 0

    3290, 0

    1249, 0

    2840, 0

    1295, 0

];

Join (MainTable)

Load *

Resident InputTable;

Drop Table InputTable;

[sunny_talwar]

It should still work the same way

[#3]

So I realized that I have to do the join because I want to do some calculations based on the new column and the other tables columns. If joining is not possible, I'll have to then do all of the calculations on the front end?

[sunny_talwar]

Well InputField is given a value of 0, what calculation you want to do on the backend for a field which will receive value on the front end?

[#5]

Right, then I'll have to do the calculations on the front end Thanks:)