Jarvis Posted May 13, 2007 Share Posted May 13, 2007 Is there a way to establish a relationship based upon a calculation? I would like the criteria for a "match" to be if a quantity field is greater than (1). If, for example, the quantity of drawers in a cabinet is greater than zero the match field criteria would validate and a portal would display. In this example the quantity of drawers could be 1,2, 3 or 4. Is this possible? Jarvis Link to comment Share on other sites More sharing options...
LaRetta Posted May 13, 2007 Share Posted May 13, 2007 (edited) I'm unsure of your structure but yes. Create a calculation (cDrawers) in your main table, number = 1. Create a relationship from this main table to your child table as: Main::cDrawers :less: Child::DrawerNumber You first say quantity greater than one and later indicate 1, 2, 3 and 4 should show. Adjust that calc as needed. If this is filtering an existing relationship, you can do so as well as Main::ProjectID = Child::ProjectID AND cDrawers :less: Child::DrawerNumber If this doesn't meet your need, we'll need a bit more information as to your existing structure. UPDATE: If your drawer quantity is an aggregate function then NO, it can't be used as the child side of the relationship. Is the drawer number a standard number? LaRetta :wink2: Edited May 13, 2007 by Guest Link to comment Share on other sites More sharing options...
comment Posted May 13, 2007 Share Posted May 13, 2007 It's possible in your example - because it's not really based on a calculation, but rather on a comparison. See the relevant help section. Link to comment Share on other sites More sharing options...
Jarvis Posted May 13, 2007 Author Share Posted May 13, 2007 Thanks to both of you. This looks just like what I am looking for. Jarvis Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6165 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