I have a database invoice that I have spent over a year creating. So far I
can use it but not the way I want to. I have the following fields that I
manually enter the data for each invocie.

Item Number,      Qty.        Product Name,          Price Each,

There are 5 lines of the above for 5 different items per invoice page.
Each one has its own field name (ie,  ItemNumber1, ItemNumber2, etc)

I would like to setup a relationship so that when I key in the item number,
the product name and price each box will automatically fill in.

I have the invoice table created and have created a new table with all the
products, I just can not get them to 'grab' the information and put it in the
invoice form.

Can anybody help me???????