Look up a drop down values from parent
I have a parent stores table and and projects child table. In cases, where we have a project established with a view to close the project, we would like to nominate another closest store that can cat...
Forum Discussion
No prob. The only question that remains is how to get the resulting list show names of stores that are currently trading. At the moment it shows everything. Also, if we could somehow use a composite field with banner and name that will be even more useful
- The composite field should contain the names of those stores that are trading. This composite field may need to be a formula field programmed to have the Store's name appear if it's trading, blank if otherwise. Then, the Store list you created from my original suggestion would instead select that composite formula field column rather than the Store Name column.
- Thanks. In creating a formula similar to the following, I get an error, Choices too long - 4385 choices specified. Field may not have more than 50 choices.
If([Date Opened] > Today() and [Banner] = "WWWW", [Store Name]) - IN this case I would not use the Multi-select Text field, but rather the multiple choice field.
- Thanks. That would allow us to select only one store which is not what we want.
