Discussion created by ChrisJohnston on Oct 8, 2016
Latest reply on Oct 12, 2016 by ChrisJohnston

I have a relationship that uses a couple of JOIN tables (pic). I have the need to do filtering based on certain criteria of many of the tables. The main filtering will take place in my SUBJECT:: table. I am looking at an idea where I need to filter through two JOIN’s. I am confused about the way that the criteria that needs to be filtered will pass through the JOIN tables. Should this be a calculation just mimicking what the actual value is? Or should it be written to a text field when the record is created? I like the idea of the calculation because it seems like things automatically kept correct. Any ideas or advice is welcome and appreciated (about the way to do what I ask or relationships). Thanks