Solved: Expression Help - Page 2

Jonathan_S · 01-10-2020 12:31 PM

Hey Guys,

Little lost,

Im trying to build an inventory App.

Contains the following components.

Vendors.
Catagories.
Items.

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.

WillowMobileSys

You are close! The expression is actually simpler:

SELECT(Type[Item Name],  
       And( [Catagory] = [_THISROW].[Catagory], 
            [Vendor] = [_THISROW].[Vendor]))

The SELECT automatically knows context so knows that Catagory and Vendor are in the Type table. [_THISROW] is only needed because the columns in the current table have the same name as what was used in the Type table (perfectly ok). But had your row columns been different names [_THISROW] could have been removed.

View solution in original post