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
Thanks Chris and Mark. So I am basically creating a new table with one field (store name and this is what want to appear as drop down to select or may be a multi select) and relating it to stores one to many. Then do I need to relate projects to this stores 2 table and have the look up field?