rlo Posted December 18, 2008 Share Posted December 18, 2008 hey guys, I'm not sure how to do what i want to do, here is the basic idea of what i want to do: I want to create an inventory list and be able to build packages to rent out from this list. I have a whole inventory layout where you can fill in the date purchased, make, model, price, and so on. I also have a place to show which package it is in and where within that package it is located So say I have Products 1 - 10 and Packages A, B, and C. Package A has compartment 1 and 2. - Product 1 is in Package A compartment 1. - Product 2, 3, and 4 are in Package A compartment 2. - Product 5 and 6 are in Package B - Product 7, 8, 9, and 10 are in Package C. How can I show first on the inventory page what package Product 1 is in and also which compartment within the package. And second if i was to make a new layout called package. I want to be able to show the Packages and have a portal to show what Products are in the Package and also what is in each compartment. i hope this is clear enough i can give you a screen shot except i haven't really done anything yet. I just don't even know what direction to head in order to make this relationship work. any help would be great! thanks! Link to comment Share on other sites More sharing options...
RalphL Posted December 19, 2008 Share Posted December 19, 2008 I would start with 3 tables: Package, Compartment & Product. The Primary Key for Package is Package_ID. The Primary Key for Product is Product_ID. Compartment will have the Primary Key Compartment_ID and 2 Foreign Keys: Package_ID & Product_ID. Relationships between Package & Compartment and Product & Compartment. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5606 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now