Hi,
I have a field called 'roomrate' on my list view.
I have configured 'roomrate' using the lookup wizard so that when I want to edit it I am given a list of values from a lookup table.
With the data that I use most of the time the lookup table has 2 or more possible values for 'roomrate' but sometimes there is only 1 possible value (which is also ok).
However, depending on whether there is only 1 value or 2 or more values the following behaviour of the lookup is observed:
Case A) Where there are 2 or more possible values for 'roomrate'
- Click Inline Edit
- 'roomrate' displays 'Please select'
- If I don't select 'roomrate' but change some other fields and save the row nothing is saved in 'roomrate'.
This is good because there are times when I want to edit other fields in the record but don't want a value in 'roomrate'.
Case <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13121&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> Where there is only 1 possible value for 'roomrate'
- Click Inline Edit
- Immediately the lookup wizard populates 'roomrate' with the only possible value - this occurs without any user intervention or action being taken. ie without 'touching' the field 'roomrate'
- To deselect the value I have to click the 'roomrate' field and click the 'Please select' message.
This is not so good because it means I can't Inline Edit the record without the system automatically populating the 'roomrate' field and I have to make an intervention step (deselecting the value) before I can save the row.
Is there anyway to change the default behaviour so that in the case where there is only one possible value in the lookup table the lookup wizard doesn't automatically select it.
Regards,
JP.