Jan 18 2004, 12:48 PM
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
Jan 18 2004, 12:52 PM
I think What I want is a SubForm? Is this right?
Jan 18 2004, 12:57 PM
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)
Jan 18 2004, 12:58 PM
PS the location of the product should be in the Products Table or in a seperate table with a relationship
Jan 18 2004, 01:15 PM
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
Jan 18 2004, 01:20 PM
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.
Jan 18 2004, 01:25 PM
Ok Thanks Trying that now
Jan 18 2004, 01:37 PM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here