By using this website, you agree to our Terms of Use (click here)
Hi everyone! This is my first post here on AUGFORUMS! I hope to be able to contribute as much as I have been able to learn.
I am experiencing an odd issue that I have previously encountered, though, with some slight differences.
Essentially, I am trying to have the "Paint" colour, populate against the relevant rows of production orders. [AMProdMatl]
It seems like a pretty simple set up, but for some reason, I am getting results coming from completely different operations/WC's
I have put this formula in the data field, which worked for the similar situation but it is not working no matter what variation of formula I try. (=IIf([AMProdOper.WcID]='PAINT', [AMProdMatl.Descr], Null)
All thoughts are welcome 🙂
Seems fine to me. How are you joining between the AMProdOper and AMProdMatl tables? That could be the issue.
Hi Tim, just a standard left join with; Type, ID and WC's as the relations. I have just noticed though, that it tends to occur when a paint colour has not been specified, it then pulls in seemingly random info from a different WC. I am going to see if I can add null condition to the formula in the hopes that it just display a blank cell.