Data in Subform

[John Hannah]

I have a Main Purchase Order Form based on a Query showing
OrderID and SupplierID. Within this I have a Subform based
on another query showing Order and Product details. I want
users to see in the subform details of only the products
supplied by the supplier in the main form. Your help on
the best way to accomplish this would be much appreciated.
Thanks! John

 

[John Vinson]

I have a Main Purchase Order Form based on a Query showing
OrderID and SupplierID. Within this I have a Subform based
on another query showing Order and Product details. I want
users to see in the subform details of only the products
supplied by the supplier in the main form. Your help on
the best way to accomplish this would be much appreciated.
Thanks! John

If the OrderDetails table includes a SupplierID field, try setting the
Master Link Field and Child Link Field properties of the subform to

OrderID;SupplierID

This will link on both fields, and you'll see only that portion of the
order which is from the selected supplier.