Two separate tables: One is Equipment with ID (Primary key) and Serial (text) - 2nd Table Orders with OrderID and Note (text)
I would like to create a query that returns the Equipment ID OrderID's where the note has the Serial somewhere - Note says Pick Up Serial: XXXX
Can I start a query - show both tables and in the Criteria (under note) Like "Pick Up"&"*[Serial]*"
So IF the [Serial] is Listed in the [Note] - then the [ID] and [OrderID] show on the query