How would I go about adding a field or a table?

[nyma96]

The attachment is the database Im working on and I have a problem.
I need to add a supplier Product number in there some where so I could keep the numbe as reference and so it may be easier to enter items recieved.
in the form section, I will have Invoice with a sub form Invoice details.
I need to put suppliers Item number somehow so it would search and if the item is on the product list it would fill out the rest of the values.

should I make a separate table for suppliers product number or should I just include that into the invoice detail? I dont want to put it in the product table since I get same Items from different suppliers.

 

[nyma96]

I decided to put the invoice item number in the invoice detail table...
now...how do I set it up so when I input the invoice item number, rest of the details are filled up using previous invoice detail table's records?(if there is any). and also how I do show the details of the product on the form?
not on the sub form but on the main form just so I could see the details...
since the products may differ only in size.
Thanks In Advance...