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
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])
If([Date Opened] > Today() and [Banner] = "WWWW", [Store Name])