AnsweredAssumed Answered

PhilModJunk - Continuation of the If script/function question from this morning.

Question asked by ChadBarnard on Aug 12, 2014
Latest reply on Aug 13, 2014 by philmodjunk

Title

PhilModJunk - Continuation of the If script/function question from this morning.

Post

     Phil,
     So the Underground field auto-populates as needed, but I'm having trouble w/ the Permit Contact information.  Since the tables are related, it's taken the first contact that matches the State field and auto-populates the fields in the Order table.

     I need to fill those fields w/ records that match the state and city.  I tried to set up the target field as a auto-enter calculation:

     From the Orders table:

          If ( OrderCity = PermitContacts::PermitContactCity & OrderState = PermitContacts::PermitContactState; GetField (      
         PermitContacts::PermitContactFullName ); "") 

     Of course, it doesn't work.  I'm probably over thinking it again. I've tried to set up additional occurrences, but still couldn't get it to work.

     Any suggestions?

      

     Thanks for any help.

      

Outcomes