It's been a while since I built that database, but yes, you can do that. Create a query that links your products to their vendors. Use an inner join between products and vendors so only matching vendors appear. Then set that query as the source for your vendor combo box.

And what I would do if you want to show different vendors and their pricing options, I'd make two cascading combo boxes. First you pick the product. That would filter the second combo box and show the vendors with their pricing. You could even make that a list box too, so it's always open.

Shallena

SELECT ComboID, Product FROM YourTable WHERE ComboID IN (SELECT ComboID FROM VendorTable);

Hope this helps,

-Raymond

Richard I couldnt find a lesson where you made the purchase order in the new lessons.  It seemed like it should be there but looks like you redid stuff up to that point... and you were adding an S to your names of things and adding * everything for all the tables for the queries... it was willy nilly chaos... what was even happening lol!  I will give your suggestions a try, I used the cascading combo boxes as my example but didnt seem to work like I thought it would. But as long as you think I am on the right track I will keep at it. It seemed like because it was a continuous form and the combo box needed to be specific to only that record that it was causing trouble.

Raymond  Had to stare at your suggestion for a minute trying to think how i would get the ComboID into the table... but then realized you are probably talking about the jumper table that joins the parts and the vendors...  That sounds like a good idea to try.  Thank  you Raymond :)

Yes, purchase orders are actually something that I never re-did in the developer series. It's on my list as soon as I finish with what I'm doing now, which is class modules. I think purchase orders will be next.

I have another question on the purchase Order.  The way it will work for me at least for the time being is when I place my order with my Vendor I will enter that information into my Form.  I have the count the items field in the footer.  I want to take the overall taxes and shipping costs and divide it by the number of items and distribute that amount to each of the item on the PO to create the True Cost of each item.  I am going to used this number to keep track of each items True cost and that will be the number used to figure out what I will sell the item for.  I have looked everywhere for a sample of what i want to do but have not been successful.  Microsoft seems to be really pushing their build a program with building blocks type program that used to be Great Plains I think,,,  that is what kept coming up.... it was super annoying.  What I did find wanted me to put the shipping and taxes in the main form rather than the subform.  I had tried having it all in the footer and the calculation worked in some rows but not others and I couldnt tell why.  Can y ou give me some direction please?  Thanks in advance!!