I will try and sum up the best I can. Access 2003. I created a "Request for Quote" database. It's rather simple. 2 Tables. Table 1 has a place for quote number, quantity, description, and date. Also has a spot to fill in for 4 vendors because we send this out to 4 different vendors at a time. So there's field Vendor 1, Vendor 2, Vendor 3, Vendor 4. Table 2 has Vendor info. Name, address, city, zip, etc... So I create a form and put in all the data. I am using a combo box to call the vendor table for Vendor input. Right now it shows Ven name, address, and etc.., but only Vendor name is stored in that field. All is well. So now I want a report to show me everything filled out on the form, but I want the addresses and tele #'s of the vendors to show up. I can't get the report to show me the details of the vendor. If I run a query I have to link Vendor 1 to the Ven table and I get Ven1's info. So I find out if I run 4 query's and change the link (relationship) I can have Query Ven 1, Query Ven 2, etc... So if I could run a query to run the 4 queries it would work, but it seems I have made things more complicated than it probably has to be. I am looking for another idea to try or way to link these tables together. I've been racking my brain for days and just can't figure this one out. HELP!