Linking parameters in Crystal Reports

See more:

CrystalReports

reporting

Hi,

I have a project and part of this project 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)
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.