Having trouble with an input box in a table grid

[#1]

Hi, I defined

Qualify*;

INPUTFIELD InputLocalBalance;

Balance:
SQL SELECT ID,
BAL, 
0 AS InputLocalBalance
FROM mdb.dbo."mytable";

in my load script, and in my table, set the expression to InputSum(Balance.InputLocalBalance), however when the table is loaded, the little arrow/box doesnt come up for me to enter a value in the cell, it just sorts. is there a property I am missing that needs to be set?

[#2]

Maybe try doing a preload with Load statement. Or store it in a qvd and then read it instead of directly accessing it from the Database through SQL Select. Example attached

[maxgro]

try with (changes from your script in bold)

qualify *;

INPUTFIELD Balance.InputLocalBalance;

Balance:

load

     *,

     0 as InputLocalBalance;

SQL SELECT ID,

BAL,

FROM mdb.dbo."mytable";

[#4]

I get a 'Duplicate keys when loading Input Field' error and dont understand why

[#5]

Added DISTINCT to the load

but still error.