AnsweredAssumed Answered

Refreshing a field from a different table

Question asked by cevans017 on Apr 23, 2017
Latest reply on Apr 30, 2017 by philmodjunk

I am so stuck.  I have a database that has two tables and they are related.

Sample:    I want to get field 4, out of record 1, and go to the other table

and see if it exists in any record of field 4.

Ex:

 

parent                      child

field 4= e1004p          field4 =f444p    = no match

field 4= e1004p          field4 =e1004p   = match (YES)

 

I have an if condition in the child table but when it goes

to the next parent record. the if field is not being

updated to the new record information.

Hope this is not confusing...

 

Thanks in advance for any help.

 

I have looked at Refresh, I have set variables but they do

not come over either.

Outcomes