Skip to Content
0
Former Member
May 19, 2010 at 02:36 PM

Problem happens when two fields trigger each other's FMS

88 Views

Hi There,

It will take a long description to explain the scenario, so please be patient. 😊

A simple example:

In A/R Sales Order screen I have BP's Catalog column and Item Code column. We want to enable the users to enter one value and get the other value automatically filled.

1) For BP's catalog field, the FMS set up as "Auto Refresh", "When Exiting Altered Column" "Item No", "Display Saved User-Defined Values", and based on the query:

SELECT T0.[Substitute] FROM OSCN T0

where CardCode = $\[$4.0.0] and ItemCode = $\[$38.1.0]

2) For Item Code field, the FMS set up as "Auto Refresh", "When Exiting Altered Column" "BP's Catalog", "Display Saved User-Defined Values", and based on the query:

SELECT T0.[ItemCode] FROM OSCN T0

Where CardCode=$\[$4.0.0] and Substitute=$\[RDR1.U_Catalog]

3) Now if I enter a value into BP's Catalog, the Item Code is filled automatically as expected, and then the FUNNY thing happens:

The BP's Catalog field is cleaned - the value I just entered there is gone!

I'm thinking that's because the 2 columns trigger each other's FMS, but isn't it look more reasonable to result in a dead loop, instead of wiping out my BP's Catalog value?

4) If I enter a value for the Item Code first, I get the BP's Catalog filled and they all stay there.

Can anyone please advise on that? All inputs will be appreciated!