I have a table containing Delivery information and another that contains Warehouse information (like below).
Delivery:
TripNo
PickupLocation
DeliveryLocation
Date
001
South Warehouse
Shop 42
02/04/2014
002
Shop 42
South Warehouse
03/04/2014
Warehouse:
WarehouseNumber
WarehouseName
03
South Warehouse
04
East Warehouse
Each truck brings home a return collection from the shop it delivers to so there are always two rows created for each trip. I had linked the two tables using the warehouse name like this:
Delivery: LOAD PickupLocation AS Warehouse
Warehouse: LOAD WarehouseName AS Warehouse
But if I select 'South Warehouse' link from my list box, it will only show Warehouses that deliveries were pickup up from (ie. Trip 001). What is the best way to accomplish selecting Warehouse from the list box and having it display both PickupLocation & DeliveryLocation (ie. Trip 001 & Trip 002)?
