Forms that have lookups - I think

[CTQ3517]

I am somewhat new to Access. I am trying to set up a form which will allow me to choose my vendor and the info about that vendor comes up. I feel sure i need to rethink my tables to make sure the relationships are right, but it gets confusing. Here goes:

I have a table with vendors and vendor info
I have a table which will house the orders i place with each vendor.
I have a product table.
I placed a lookup in the order table so I would be able to choose my vendor.
I want to create a form that will allow me to choose my product and vendor info pops up and I need only key in the quantity and type of order

Can you help!

 

[Marvin88]

I'm struggleing with a similar issue. My first suggestion is to open MS's invioce DB and look at it, theirs works correctly. I've modeled mine after theirs and mine doesn't so I posted a thread myself. This is a good place to start and study the relatioships.