Pull Enum and or enumlist from another table

[Shock]

Hello,

I am having an issue pulling in data from another table. I have done this before with data validity and refs etc etc but those moves are not working. 

So, i have many inventory tables . The goal is to perform a check on different vehicles who have  items from these inventory tables. I want to do that instead of listing the items in the vehicle table because they do get moved around and it would be a pain to add and remove things from the vehicle table when i could just simply switch the vehicle and location from an inventory table.

I have a filtered view right now that pulls that inventory view from the location and vehicle i am requesting perfectly in the vehicle check form. If i was able to edit that filtered view, it would be perfect but of course i cannot so, its mainly there for motivation.

filtered view, base type ref, 

FILTER(
"Water Appliances Inventory Check",
AND(
([Subcategory] = "Fitting"),
([Apparatus] = [_Thisrow].[Vin]),
([Apparatus Compartment] = "Bumper Compartment 1",
)
))

How do i pull in the items from these inventory tables?

Select Working but not editable

Select(
Water Appliances Inventory Check[Equipment Description],
And(Water Appliances Inventory Check[Apparatus] = Vehicle[Vin],
In("Bumper Compartment 1",Water Appliances Inventory Check[Apparatus Compartment])))

Each individual Vehicle table uses Inspection ID as the key. It is also a part of the main Vehicle table which uses the vin as the ID which lists all vehicles and related inventories nicely. ( The challenge being getting this into a daily check)

Inventory tables use Equipment ID as the key. It is also a part of the main Vehicle table

[1minManager]

Its a bit confusing what you're asking for here.  Trying to pull multiple things from multiple tables can be clunky.  But I've not aware of anything in Select() that would make them readonly.

Simon, 1minManager.com

[Shock · Accepted solution]

Disregard. I moved the Expression out of the formula and into the valid if and its pulling correctly. 

Select(
Apparatus Inventory Items[Equipment Description],
AND(
([Subcategory] = "Fitting"),
([VIN] = [_Thisrow].[Vin]),
([Apparatus Compartment] = "Bumper Compartment 1",
)
))

[Shock]

It is , I have made my inventory items (is a part of) the main Apparatus Table and from the vehicle check i am correctly pulling in my items using:

Select(
Apparatus Inventory Items[Equipment Description],
AND(
([Subcategory] = "Fitting"),
([VIN] = [_Thisrow].[Vin]),
([Apparatus Compartment] = "Bumper Compartment 1",
)
))

However, I do not know why it is read only. 

[Shock]

I would like to have those items Appear in an Enum list