millmaine Posted November 6, 2015 Share Posted November 6, 2015 We have a table of Suppliers. We also have a table of Tasks. When defining a Task, the user chooses a Supplier from a value list that is filtered by Territory. i.e. the Task will have a Territory defined and only the Suppliers operating in that Territory are selectable. However there are some Suppliers that work across ALL territories. I would like to have a way that these Suppliers are included in the value list for ANY territory, so if the Task has the Territory defined as (say) Sydney, the value list will show the Suppliers relevant to Sydney AND Suppliers that cover all territories. Ideas? Link to comment Share on other sites More sharing options...
comment Posted November 6, 2015 Share Posted November 6, 2015 Use a calculation field (defined in the Tasks table) = List ( Territory ; "All" ) as the matchfield for the relationship, instead of the Territory field. Link to comment Share on other sites More sharing options...
millmaine Posted November 7, 2015 Author Share Posted November 7, 2015 Perfect. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3097 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