Query to return data form one table using user entry critiera

[cement]

Hi

i have a Table1 with:
ID (number) - itemName (text)



and a table2 with a
Name (text)
which currently is holding the relevant ID from Table1

i want a query so that the user enters the desired itemName (from Table1) and it fetces the ID (from Table1) and shows the relevant data from Table1 whose Name equals to the ID taken from Table1.

how can it be done ?
thanks in advance

[alansidman]

In your query, you will need to join the two tables on the common field. How are you doing your search/lookup to start the query?