Hello,
I use a table as lookup table for data input in another table.
The lookup table structure is like this
b_id int(11) NOT NULL AUTO_INCREMENT,
b_type tinyint(10) DEFAULT
b_name varchar(30) DEFAULT NULL,
b_value decimal(25,1) DEFAULT NULL,
In that table I have data like this
1 1 0 0,0
2 1 0.5 0,5
3 1 1 1,0
4 1 1.5 1,5
5 1 2 2,0
6 1 2.5 2,5
7 1 3 3,0
8 1 3.5 3,5
9 1 4 4,0
10 1 4.5 4,5
11 1 5 5,0
12 1 5.5 5,5
13 1 6 6,0
14 1 6.5 6,5
15 1 7 7,0
16 1 7.5 7,5
17 1 8 8,0
18 1 8.5 8,5
19 1 9 9,0
20 1 9.5 9,5
21 1 10 10,0
22 1 10.5 10,5
23 1 11 11,0
24 1 11.5 11,5
201 1 100 100,0
202 2 Grootste onderscheiding + 0,0
203 2 Grootste onderscheiding 0,0
204 2 Grote onderscheiding + 0,0
205 2 Grote onderscheiding 0,0
206 2 Onderscheiding + 0,0
207 2 Onderscheiding 0,0
208 2 Voldoening + 0,0
In the edit page I use this table as lookuptable for data input in another table with a dropdown box in the field properties.
I use b_id as link field and b_name as display field.
Now I would like to be able to use the keyboard for input as most data or just numbers from 0 to 200 with some strings in the + 200 range.
Problem:
When I would like to input number 11 in the input box I get first 1 then 1.5 then 10 then 10.5 and finaly 11
How can I build the dropdown box so that I can imediately select a number using the numeric keyboard.
The problem happens with all numbers with 2 same digits.
Like 11,22,33,44,55 etc.
Hope I did explain myself good.
regards,
Johan