SQL string problem... take a value, take the ID, search for the ID

[KingJ]

Hi,

I would like to write allot of text here, but i know that I would just be waffling!

What I have is a combobox that displays all of the Location Names in a form. (this works perfectly) What i want is to take the Location Name that the user selected and look in the Location Table Table for the Location ID.Then to get all of the records in the Stock Table with the Location ID as a Foreign key and put the the Name of the Item of stock (that was found) into a separate Combobox.

For more info: see my post below.

There must be a simple way to do this, I have had a look on google and tried the JOIN method,but that doesn't work! IT doesn't do anything at all.... its bugging me.

I'm using Access 2010 and Vb.net 2008 with OLEDB

Any help would be appreciated.


Thanks

John.