I imported my supplier files from Excel and everything lined up nicely.
I put a dropdown list on Product and Supplier.
However, when I click on a supplier's name, that's the only thing that changes.
I would like to click on a supplier's name and have all the information come up that is related to that supplier.
Also, the same for Products. If I select a product from the Product List, I would like the Supplier to come up.