If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I create an assembly in Access?
I'm creating an inventory database and want to combine items into assemblies
ie batter helmet, face mask, chin strap together are helmet assembly. The helmet assemblies would be placed in team bags but each individual part may have to be replaced at different times. |
#2
|
|||
|
|||
You will need to add a ParentID field to your inventory table. Each item in
the assembly would have the InventoryID (or whatever your primary key is called) of the assembly in the ParentID field. You would have to have a record in the inventory table for the full assembly. InventoryID Description ParentID 101 Helmet Assemblly 102 Batter Helmet 101 103 Face mask 101 104 Chin strap 101 It can get a lot more complicated than that, especially if a particular part could be used in multiple assemblies, but this should get you started. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Lilshulf" wrote in message ... I'm creating an inventory database and want to combine items into assemblies ie batter helmet, face mask, chin strap together are helmet assembly. The helmet assemblies would be placed in team bags but each individual part may have to be replaced at different times. |
#3
|
|||
|
|||
Thanks
Can you explain how to handle it when a part (chin strap) is used in two different assemblies? We have two helmet manufacturers. They make their own face guards but the chin straps are universal. "Lynn Trapp" wrote: You will need to add a ParentID field to your inventory table. Each item in the assembly would have the InventoryID (or whatever your primary key is called) of the assembly in the ParentID field. You would have to have a record in the inventory table for the full assembly. InventoryID Description ParentID 101 Helmet Assemblly 102 Batter Helmet 101 103 Face mask 101 104 Chin strap 101 It can get a lot more complicated than that, especially if a particular part could be used in multiple assemblies, but this should get you started. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Lilshulf" wrote in message ... I'm creating an inventory database and want to combine items into assemblies ie batter helmet, face mask, chin strap together are helmet assembly. The helmet assemblies would be placed in team bags but each individual part may have to be replaced at different times. |
#4
|
|||
|
|||
One way to do it is to create a "phantom" record that merely serves as a
holding record for the steps in the final assembly. InventoryID Description ParentID 101 Final Helmet Assembly 102 Batter Helmet 1 105 103 Face mask 1 105 104 Chin strap 101 105 Helmet Assembly PH1 101 106 Batter Helmet 2 108 107 Face Mask 2 108 108 Helmet Assembly PH2 101 Then when you go to put together a Helmet assembly you have to choose the appropriate phantom record, which consists of the appropriate helmet and mask. The chin strap is, in this case, always included in the Final assembly. Obviously, phantoms can go down to multiple levels. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Lilshulf" wrote in message ... Thanks Can you explain how to handle it when a part (chin strap) is used in two different assemblies? We have two helmet manufacturers. They make their own face guards but the chin straps are universal. "Lynn Trapp" wrote: You will need to add a ParentID field to your inventory table. Each item in the assembly would have the InventoryID (or whatever your primary key is called) of the assembly in the ParentID field. You would have to have a record in the inventory table for the full assembly. InventoryID Description ParentID 101 Helmet Assemblly 102 Batter Helmet 101 103 Face mask 101 104 Chin strap 101 It can get a lot more complicated than that, especially if a particular part could be used in multiple assemblies, but this should get you started. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Lilshulf" wrote in message ... I'm creating an inventory database and want to combine items into assemblies ie batter helmet, face mask, chin strap together are helmet assembly. The helmet assemblies would be placed in team bags but each individual part may have to be replaced at different times. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
How can I create a search field in a data access page? | Briana Fiji | General Discussion | 1 | November 19th, 2004 07:51 AM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Access user profile | Michael Breitsameter | General Discussion | 7 | July 23rd, 2004 07:47 AM |