Our strategy for lookup fields is to use a short code for the value of a lookup field (max 4 chars) and use a 50 varchar value to display in a drop down field. To do this we create a lookup table with the value and display fields. This has worked well in other development environments but not in ASP.net so far.
Using a form view in the Item Template. The system wants to display the value (short value) in a label, but we would like to display the long value in the field. So I have added drop down lists for these fields by editing the field templates. All is well except it allows the user to modify the value, although the new value is not posted. This will confuse the users. So I tried enable="false." this works but the field is grayed out. Looks wierd.
Is there any way around this using the drop down list. In Access for example there is an enabled property and locked property. Lock does not gray out field. Can't find a lock or anything that should do what I need. Am I missing something?
Is it best just to save the long value in the underlying table and forget about short values?
Any other strategies?
Thanks for your help