Triggers Not Working on inline field

[pradnyat]

Hi All,

We are facing one issue while writing the triggers. We have loaded 1 inline table Geography with 4 values:

State, Franchise, Territory, HCR.

We have 4 different fields for the same which are coming from back end.

The intended functionality is, when we are selecting inline Geography with any value all the other 3 selections should be cleared and minstring of selected geography should be selected, this will work fine when we have the associated values.

But e.g.  in case where we have selected any State for which no Franchise is associated and then we are selecting Geography as Franchise then minstring trigger is not working.

We are using field event triggers on inline field Geography.

Please find the attached sample document.

prakashpawar

[pradnyat]

Is there any other workaround for this issue??

[saumyashah90]

As i said earlier.

This could be the workaround:

Load all these field as different table:

All three fields i.e Franchise_Territory_Number

Geography_Code

and

Territory_Number

Load all three fields as different tables like:

load

Franchise_Territory_Number

from abc;

Load

Geography_Code

from xyz;

Load

Territory_Number

from pqr;

[pradnyat]

From back end we are getting all the things in 1 one table and we can't load it from separate tables as there are other fields also which we need from same table.

[saumyashah90]

You can break down the table once loaded:

Forexample you have:

Table:

Load

Franchise_Territory_Number,

Geography_Code,

Territory_Number

From xyz;

Load all three fields as different tables like:

Table1:

load

Franchise_Territory_Number

Resident Table;

Table2:

Load

Geography_Code

resident Table;

Table3:

Load

Territory_Number

resident Table;

Drop table Table;

[saumyashah90]

Are you able to do it?

[#7 · Accepted solution]

Hi Pradnya,

PFA,

Hope this will solve your problem.