Crystal Reports Adding Where to Select Field

Message

   In SQL, I would do this on the join - could also be a subquery.  

My company has a table of customer IDs that has a composite primary key.  Because of many mergers, a customer might have up to 5 IDs.  It want to select CUSTOMER_ID from that table only where ID_TYPE = 3.  

In Crystal, is there a way to do this with a simple formula that can then be used as a field in the report?  I will have to do this a lot and would like to avoid using SQL commands or subreports every time, if possible.