I thought this would be easy to do but Filemaker makes it a lot harder than it needs to be.
The situation is as follows:
I have a table of work orders. During production we combine several work orders into one - one work order then becomes the "head work order" which contains all the job info. The other work orders have a field called "headworkorder" which contains the number of the main work order. Using a self-referencing table, this works great.
Now, what I want, is to make it so I *only* see the head work orders when I push a certain button. Basically, if the orderID and the headorder are the same, then the work order = headorder.
I thought a simple "Perform Quick Find" would be possible but it's not. I tried the follow Quick Find:
orders::headorder = orders::orderID
But Filemaker does not like this for some reason since the button doesn't work - I assume it's because orders::orderID is a variable that changes per record.
I tried a Find Request which didn't work either. Anyone have a simple solution to this? It's odd how something so simple seems to be so hard to solve (at least for me). Right now I have to use a field that gets "ticked" when it's a head order and then I filter by that field but that's a sloppy way to do it.