Im trying to build an inventory App.
Contains the following components.
I have a form regarding the inventory and As the user fills out the form, I only want the items to show up in the enum based on the Vendor and Catagorie they selected.
This is the formula I am using in the Valid If field of my Item field.
SELECT(Type[Item Name], And(Type[Catagory].[Catagory] = [_THISROW].[Catagory], Type[Vendor].[Vendor] =[_THISROW].[Vendor]), FALSE)
It currently returns Blank. If I don’t have this expression it Contains all types from all vendors and categories.