Dear Friends,

I am working with a School project, and I am very confused while working on Fee Receipt layout. I want that if a student has deposited the fee for a particular month, then the Collection Department or Student should be not be able to recollect or deposit the fee again for the same month.

For example, if a student has deposited the fee for month 'January, 2011', then Collection Department or the student should not be able to recollect ot deposit the for the same month again, i.e., 'January, 2011'.

Therefore, I need your help in doing so. If someone having some solution regarding this, please let me know about it, and if possible please send me demo of the solution of this problem. You can also send me a copy on '[email protected]'.

Thanks...

Not sure I understand exactly what you mean by "not be able to recollect or deposit the fee". Perhaps you are looking for validation - if so, you need to define a new text field, set it to auto-enter a calculated value (replacing existing value) such as:

StudentID & "|" & FeeMonth

and validate the field as 'Unique, validate always'.

Thanks a lot for this it is working...

But is there any other way, to do the same, using ValueList or something like this???

Again, I am not sure what you mean.

I mean to say, i need a value list which will work dynamically. Suppose, if I have taken the fee for January 2011, in ValueList January should not be there in the list. It should be started from February. It should be vary according to StudentID of the student.

Example, if S0001 has given the fee for January, the ValueList should be from Feb to Dec, but for others like S0002 it should start from Jan to Dec...

Thanks

Search the forum for 'dwindling value list'. Note that this is merely a cosmetic measure - it should not be used instead of validation.