Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Hi,
In my Sales table there is field customer_id, based on PopLov call customer name in LOV. Right now facing two issue in this regards.
1.am unable to enter customer name by typing for example, if customer name “ABC” and type same in lov then don’t allow rather open LOV. 2.unable to delete data from customer field, once entered.
Thanks.
For Pop LOV, there is an option Manual Entry, enable it, and both the issues will solve.
You will find this in the Settings section of the property palette.
HI,
This is allowed user to enter data without list but also it doesn’t validate the no, For example customer number 1 which is define at setup level, however, when i enter 2 customer id which doesn’t exist at setup level despite date system not validate, this is the bug,
Thanks.
You will have to write a validation on your LOV item to validate the entered value.
Thanks Vinish,
I will apply the validation, But now where can store code, Let suppose, i have customer name which select from LOV and code automatically store at backend. However, when set LOV as manual then user may able to do any value at from-end but validate run make sure either this customer name exist or not, if exists then it will allow.
Now Question is what about the customer_code which is stored behind, what about in this case.
Thanks.
In this case, you should not allow the user to enter the name manually. Let him pick only from the Pop LOV, and you write the validation to validate the customer code.
If allow user select pick from lov then it again take time, As in oracle Forms user can enter value manually or take it from list which validate form it self.
Is there any workaround, so user can select values either list or manually and customer_id alos can be stored.
Thanks.