We are using Crystal Reports 7 and I have three tables that I need to link together. One table has production scrap information. The other two have the production order information. They are linked by the production order number. One of the production order tables has all the past orders, the other one has the current orders. The scrap table contains the info for all orders. I would like to be able to link both of the order tables to the scrap table, so that if the production order number from the scrap table is not found in the current order table, it will pull it from the past order table. Is this possible? Thanks.