Hi,
Jet newbie here. I'm trying to create two tables that are using the same fields and filter out the SOs (No.) that are showing up in both the tables (Sales Header and Sales Header Archive) so the SO will only show up on one table or the other.
Any thoughts?
Hello Jason -
I assume you are using two NL functions [either NL(Table) or NL(Rows)].
There is no way to make one NL function dependent upon the results of another.
What you could do is to create NL(Filter) functions to control what you want to see.
Let's look at a simple example. Let's assume I have the following data:
In my first list, I want everything in Sales Header. In my second list, I want everything from my Sales Header Archive that is *not* already in the first list (i.e., I want to *not* show #5 through #9).
I could create NL(Filter) functions to create sets of the No field for each and then use an NP(Difference) function to separate out the duplicates.
Then, when I create an NL(Rows) for my second list, I would filter it based on the values in the NP(Difference) function.
Something like this:
When I run my report, I'd get this:
I hope that helps get you pointed in the direction you need.
Some of that makes sense, but I'm still too new at Jet to understand the different functions. I'm going to really need to sit down and try to read more and watch videos. Reading the documentation gets overwhelming since I still don't have a good grasp of NAV yet either.
Thank you for the example!