Crystal Reports Linking Parameters in Crystal Reports XI

Message


   I have a project and part of this project it is in Crystal Reports
It is not required to use VB/VB.Net code just Crystal Reports and Sql commands (retrieving data from the database)
The interface is something like this


And I have 2 Tables:
PurchaseOrder
- PurcaseOrderID
PurcaseOrderLines
-PurchaseOrderID
-PurcaseOrderLineID
-PartID
-RevisionID
I want to  give the user the option to enter the data for OrderID and then to link this parameter with PartID (retrieve the data from the table-database)
Something like :
SELECT PartID 
FROM PurchaseOrdersLines 
WHERE EXISTS
  (select PartID,PartRevisionID
    from PurchaseOrderLines
    where PurhcaseOrderLines.PurchaseOrderID = PurchaseOrders.PurchaseOrderID
    And  PurcaseOrderLines. PurchaseOrderID= {?OrderID}
 
 
Or
 
 Select PartID
From PurchaseOrdersLines INNER JOIN PurchaseOrders ON PurchaseOrders.[PurchaseOrderID] = PurchaseOrdersLines.[PurchaseOrderID]
 Where PurchaseOrders.[PurchaseOrderID]={?@OrderID}
 
Thank you  in  advance