AnsweredAssumed Answered

calculation over a relationship possible: Hi all,  quick question I have:  2 tables relationship is...

Question asked by Immigranta on Jan 27, 2012
Latest reply on Jan 31, 2012 by philmodjunk

Title

calculation over a relationship possible: Hi all,  quick question I have:  2 tables relationship is snpk = snfk. Table one has the pk and I try to create a calculation field cfield in this take  that looks over the relationship whether  : case (  table2:: field1 = ”pop” and table2::field2=”rock”; 1; 0 ). This will be a check box that will show if the calculation is true as checked. .there are multiple record in table two with the same snfk. It does not work for me. when i am on layout based on table one and place table2:: field 1 it gives me only one valeuof I think of the first record that maches the relationship. Could explain why and help me to find solution? I hope I can do it without a table occurrence.  Thanks a lot

Post

Cool

Outcomes