List name not repeat in collection filter

Hello Everyone,

This function will help others developers a lot also.

I have created a collection, and now I want to add filter in the list as per line. Like if the name is already entered in the previous fields it will not be available for the selected field.
Or previous field's name will be removed from the list.
Like it happened in the price list report, When we enter a stock item name, it will not be available in the next field.

Please help......


[#Menu:Gatewayoftally]
Item:Coll List:Alter:Coll List
[Report:Coll List]
Form:Coll List

[Form:Coll List]
Part:Coll List
Full Height: Yes

[Part:Coll List]
Line:Coll List
Repeat: Coll List : Coll Aggr
Break On: $$IsEmpty:#CollList
Scroll: Vertical

[Line:Coll List]
Field:Coll List

[Field:Coll List]
Use: Name Field
Table: Coll Aggr
Show Table: Always
Set as:$$Value

[Collection: Coll Aggr]
Title: "Coll list"
List: "abc", "def", "ghi", "jkl", "mno", "pqr"
Full Height: Yes
Align: Right

 

I think there is a attribute at field level "Common Table", that will help you achieve it

 

http://tdlexpert.com/index.php?thre...-the-table-displayed-in-a-repeated-line.2852/

 

Thank you sir for replying.
My problem is solved.
Thank you.