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.