Hopefully I can explain this with out confusing too may people.
I have 3 tables.
Suppliers --> Manufactures --> Products
- Manufacturers have one supplier.
- Products have one manufacturer.
I need to create a script that goes to a layout and show all the PRODUCTS the SUPPLIER has. For some reason I can not get my 'Preform Find' to only show related records, it just ends up showing all PRODUCTS.