I have a number of simple lookup tables in a MSSQL database. For simplicity, lets say that the lookup table contains just 2 fields:
Field1 - Primary Key - SysID - Int
Field 2 - Description - Char(35)
I set up a standard netweb form, for a table, called products, and I have a sysID field in this Products table. I want to use a lookup on this form, to return the SysID value into the table, and display the description on the form.
Everything works fine when I have alpha numeric values in the description field, but one one my customers has taken to entering a numeric description!! They are actually using the lookup table to store colours, therefore:
SYSID Description
1 Blue
2 Green
3 Red
4 Pink
5 2
When they enter 2 into the lookup field on the form, it appears that the Nettalk template is being "clever" and thinks that the user is smart enough to be entering the sysid value, and so when the form is saved, I find that a sysid of 2 has been placed into my table rather than 5 as I would have wanted.
Is there a way that anyone knows that I can work around this behaviour, short of asking my customer to prefix the number in the description field with an alphabetic character?
I'm loath to suggest this is a bug, as if I've understood it correctly, I think this is very clever, and my customer is being a little unhelpful by placing numeric values into somewhere that they weren't really supposed to, but I do have to give them a solution?
Does anyone have any thoughts?
Regards,
Neil Porter.