I need help with referencing columns in another table.
I am trying to create some expressions that are like refs without being refs because I cannot having something as a label.
I have a column named [Plant ID] in another table.
It is the key of the table, but not the label.
I cannot change this.
Have tried to no avail.
It won’t be changed.
In my current table I also have a column named [Plant ID] and I am creating a drop-down menu by referencing the other table.
I used this in the Valid-if field which worked.
=Design Numbers for 2018[Plant ID]
So as I’m filling out this form, I select a plant in the Plant ID field/column.
All good there.
Now what I want to happen is for both the main planting dates and the price per plant to pop up automatically when the Plant ID is selected.
Thus far, I was successful with the First/Main Planting Date.
I used this equation in the Valid-If field:
=(Design Numbers for 2018[First/Main Planting Date, Week Of]).[Plant ID]
Now, when I try to do the same for the Price Per Plant column, it says “could not be parsed due to exception: Object reference not set to an instance of an object”
What does this mean?
Why is it not working?
I feel like no matter what I do I keep having issues with creating stupid drop down menus.
I have tried several different things, saving & verifying which takes forever.
At my wits end with this thing.
You help is appreciated. Miranda