Auto Fill selections from list
I have two forms, one for Product information and one for Supplier information. The Product information for has a supplier list linked to the supplier information form, and the Supplier information form has a products list linked to the Product Information Form. Is there any way to have the list auto-select/fill the products name from the Product Information form when I select the corresponding Supplier Name in the list from the Product Information form?