Relationship for invoices

[Guest]

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???????

 

[Stefan Hoffmann]

hi,

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.
Can anybody help me???????

Examine the Northwind.mdb.

mfG
--> stefan <-