Heres what I am trying to do.
I want to enter in information about a product that we receive. Then when I enter in the Product ID I want a list to come up and say where other similar products are stored at in the warehouse. i am not sure how to do this Any help would be much appreciated

Thanks
Chris

I think What I want is a SubForm? Is this right?

You need a related product table with 4 fields(or more if you like

RelatedProductID - PrimaryKey
MasterProduct - ProductID from Products Table
RelatedProduct - Again Product Id from Product Table

Master & Related producs should be combo lookups, This way you can have as many related product as you wish attached to whichever products you can then use this table to bring up related products on your product forms etc.
hope that makes sense)
HTH
Craig

PS the location of the product should be in the Products Table or in a seperate table with a relationship

Ok Now from that list i have I want it to display in a field at the bottom of the form where other Like IDs are at. so i will pull the information from another table and display it

Not quite understanding what you mean, you can create a subform from the related products and you would join the form contents using the productId on the products form as the Primary Key the the Master products field as a foreign key - from within that subform you could add/edit /view related products.
I would create a subform in design view drag and drop the form unto your products for which will create the parent/child link between the forms.

Ok Thanks Trying that now

Ok I think that I have got a better wording. I would like it to be like a "find" box you type in what you want to find ie.ItemID and it will return all values with same ItemID and will also show the other valuse assoicated with that ID