Value List Not Populating Correctly
Ok, I didn't set this up and something about it seems wrong. But, I'm going to ask the group for help and see if I can figure out what's going on here and how to correct it.
I have a table WorkOrders and it has a relationship to another table Spool Invenoty_WO via a text field WorkOrders::Empty to Spool Inventory_WO::Current Status. The Empty field is set to Empty but when you go to look at the drop down list, it pulls every value regardless of the "Empty" value. I'm not sure what's going on here, but it doesn't seem to be doing what was intended at all.
The intent is that when you hit the drop down list it only shows the Spools that are Empty. I'm not fond of the way this is put together but I think it should be working.
Any help would be appreciated!