AnsweredAssumed Answered

Pulling Data from Table two to Table One

Question asked by gsbilsky on Feb 12, 2010
Latest reply on Feb 13, 2010 by LaRetta_1

Title

Pulling Data from Table two to Table One

Post

I have the following in calculated specify

 

Set Field [Bankdata::BankReportingData ; If(BankData::BankPayee = Payees_W_Cats::WherePayee; Payees_W_Cats::ReportingPayee; "Opps")

 

I checked specify target field and Have Bankdata::bankReportingData selected.

 

 

I am in the field need and run script and get Opps.

 

If I replace payees_W_cats::Wherepayees with text = to BankData::BankPayee the statement works.  

 

Somewhere I must not be looking at Payees_W_cats.

 

What am I doing wrong?

 

Second Question:  How do I update the BankReportingData fields for  records and not just one at a time?

Outcomes