Pipelines Condition Record ID Equals

Does anyone else run into this issue - I am wondering if it is a bug or I am doing something wrong.

Example:

Table A: Requests
Table B: Orders
Requests have many orders. (So Table B include field "Related Request").

Goal: Table B changes. It changes something in Table A.

Create pipeline.
Trigger: Table B Changes
Search Table A where Record ID = Related Request

This yields NO results. However, if I create a field in Table A called 'Record ID Mirror', then:
Search Table A where Record ID Mirror = Related Request

This works fine. ???? Anyone else find this?

------------------------------
Mike Tamoush
------------------------------