Need a little help
I have a drop down selector on a project specific page that is a look up of project names from a main project dashboard. When I create a new project I find the project name in the drop down box and select it. Doing so allows me to filter tasks so only project specific tasks are shown on each project specific page.
I am trying to make it so when I select the project name from the drop down list that the project code automatically displays on a different line (The project name and project code are stored in the table tables called “Projects”).
I cannot get the project code to automatically change based on the selection of the project name like I need to.
Here is a copy of the doc so you can review. Its the first two “things” on the sheet.
To check to make sure it works correctly you should be able to select “Fusion Flood” and have “FF” show up for the Project Code.
Any help would be greatly apprecaited!