Set 1 or 0 to variable if selected field is on a specific table

[#1]

Hello,

is it possible to set a variable with the result 1 or 0 if selected(s) field(s) is(are) on a specific table?

I have 3 tables (Table_NAV; Funds;Memory) and a reference date set by a variable (vDateRef)

Table_NAV		Funds		Memory
Date		Funds_Nbr		Contract_Nbr
Funds_Nbr		Type		Funds_Nbr
NAV		Name		Date
		ISIN		Units
		StartDate

The 2 first have date all days. Last one only endmonth.

Wath I want is use the vDateRef if selected Fields are on table "Table_NAV" or "Funds" otherwise a endmonth date if selected fields are on table "Memory".

thanks for your help.

Laurent

[its_anandrjs]

Hi,

You need to use Getfieldselections() function to fetch the value of the filelds and match the values according to that you check the fields and set value of variable.

Regards,

Anand

[#3]

Hello Anand,

Thanks for your suggestion.

Unfortunatly, that doesn't help me for this. If there was the same function but with the table it could. What I was trying to do was affect a value to a variable if a field is selected in a defined table (regardless of the field) and an other value if its a selected field from an other table.

But your suggestion have help me for other expression.

Regards

Laurent