K
kmmuelle
I want to create a form that will show a vendors address. however I want the
user to be able to search by product or vendor name. The way I have set up
my table is that I have one with a list of suppliers, and a list of the
products. then a table of the address and which items the supplier offers.
so there can be more than one item to each supplier. I'm not sure how to do
this .. if my tables should be change. my problem is that i can search by
only one supplier and not items and vice versa. Is there any way I can have
more than one record source for a form?
user to be able to search by product or vendor name. The way I have set up
my table is that I have one with a list of suppliers, and a list of the
products. then a table of the address and which items the supplier offers.
so there can be more than one item to each supplier. I'm not sure how to do
this .. if my tables should be change. my problem is that i can search by
only one supplier and not items and vice versa. Is there any way I can have
more than one record source for a form?