Thank you Edward, as usual you are very helpfull.
Your solution would require to put this view as updatable. I wonder if I can add it directly in the view definition. I created it with the following command :
CREATE SQL VIEW "vapban" ;
AS SELECT ident, code, name;
FROM APSupp;
WHERE APSupp.Sup_Type = "B";
ORDER BY APSupp.Name
Can I do a UNION or something to add 0,"","[None]" ? What do you think?
Eric.
>>I have a customer form with a code that is selected by the user from a combobox dropdown list. This dropdown list is feeded by a view. It works very fine: when there is a code in the current record, it shows the good description in the dropdown list and when it is zero, nothing shows. When the user select a particular code from the dropdown list, everything is saved ok.
>>The problem is if the user wants to put 0 (no code). The drop-down list doesn't allow to put it. Is there a way?
>>
>>Thanks.
>>Eric.
>
>One good way is to 'improve' your view, e.g. in Form.Init event:
>Select myview
>Insert Into myview Values(0)