I am trying to use set criteria to use 2 different fields in a bidirectional look up to sort my data.

in my engine view I define what ships can use that engine.  and also define whether the engine is a main, mjet or scram. 

I would think the code above would only show me engines (in my warship view) that work with the listed warship and also need to be defined as Main.

However it seems to only pay attention to the first part Warship_Name == input.Warship_Name.  that part works great and changes on the fly as I add and subtract ships name from the list.

It does not sort out the engines by their classification at all.  So even though I have multiple engines that can work on a certain warship as a Main, I also have one defined as a Scram and it shows up as well.

Im am curious if I can sort by multiple criteria for a bidirectional field and if so what am I missing to allow me to do it.

thanks.

Dell