AnsweredAssumed Answered

Perform Find / Replace in a Script Not Working

Question asked by TSADesign on Aug 9, 2010
Latest reply on Aug 10, 2010 by philmodjunk


Perform Find / Replace in a Script Not Working


Question 1:

I have a script that is being triggered by a check box / button in a table that is to add data into matching records in another table. The check box is matching records from Table 1 to Table 2 through a field that shares the same data, i.e. Part Number. The issue I'm having is that there are multiple instances of Part Number in Table 2. My script update the first instance, but ignores the other instances.

My current script is as follows:

If [GetAsNumber(RFQ::Field_1C) = 1]

   Set Field [Table1::Field_1C: ""]
   Set Field [Table2::Field_2C: ""]


   Set Field [Table1::Field_1C: 1]
   Set Field [Table2::Field_2C: Table2::Field_2A]

End If

Questions 2:

In trying to use Perform Find / Replace I obviously did something wrong, and one of the records I was using to test will not display the portal data any longer. All other records are fine, but I can't figure out how to get this record to display the portal data again.

Thank you for your help on this.