scottvaughan Posted May 5, 2006 Share Posted May 5, 2006 I have a portal that links to our main DB. It will list all of the jobs in house for a specific customer. It works great. But I want it to only show jobs that have not shipped. I need to "filter" out everything whose status field ≠ shipped. Any ideas how to do this? Link to comment Share on other sites More sharing options...
John Mark Osborne Posted May 5, 2006 Share Posted May 5, 2006 In your Interface table, create a calculation field with the value "Shipped" as the formula. You could use a global field but since it global values are removed when you save a clone and can be different on each guest in a multi-user scenario, I think a calculation works best. Then, create a relationship from your Interface table to the Jobs table using the calculation field and the shipping field. Set the relationship operator as not equal (≠). This will display all jobs that haven't shipped. Link to comment Share on other sites More sharing options...
elysive Posted May 22, 2006 Share Posted May 22, 2006 (edited) What if you have a similar problem but want to omit all dates not listed in the original Find criteria? If I'm searching Jan 06, that would mean month field != Feb Mar Apr May Jun etc. and year field != 07 08 09 etc. Right now my Find criteria only filters a related table (geography, so all records are listed per filtered geography, but I want to omit records from different dates). Edited May 22, 2006 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6520 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now