Hi All,

I have created one customized session to enter some data. In that I need to enter data reason wise. I want such functionality that user will be able enter reason distinctly. No duplicate reason will be allowed.

Thanks in advance...

Hi All,

I have created one customized session to enter some data. In that I need to enter data reason wise. I want such functionality that user will be able enter reason distinctly. No duplicate reason will be allowed.

Thanks in advance...

Hello,

index on reason !

or be more specific about the requirement.
Regards

Hi,

That is what the purpose of is. For this the table in which you are entering data through session, requires reason as index field (to be specific primary index).

The rest of the things will b handled by Baan.

Vishal

In 4c4 in one session I just added a check.input section in a baan standard program using qkey. All it did was check the maintable on the session to make sure that a reference number was unique. But the best suggestions are to make it part of an index and let baan handle it. I could not do that since we do our best not to modify baan standard tables.

Put "reason" as a key field 1 of the Primary index of the table. And if thats not feasible, create a dal for that table and in "field.check", put the code for comparing the reason entered with the existing reasons in the table , and if thats not feasible, considering you dont want to create a dal, just put a check.input for that field in the UI. You should do just fine.