|
| 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
November 18th, 2005, 02:59 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Parts Management
Hi,
i'm a newbie at this database programming. I've looked at some examples but cannot solve this query! I'm trying to create a database for my place of work which can deal with "parts" that are made up of "parts". I want to create a table called parts which has a number of fields to do with the parts e.g like part no, description etc... I'm not however how to create the hierarchy structure in the database? For example; A bicycle is made up of a wheels, which consist of tyres and a rim Can anybody help? Thanks 
|
|
#2
November 18th, 2005, 04:19 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Parts Management
Search for:
Bill of Materials There's a sample database you can download and convert to your version in this link: http://www.mvps.org/access/modules/mdl0027.htm -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Meak" wrote in message ... i'm a newbie at this database programming. I've looked at some examples but cannot solve this query! I'm trying to create a database for my place of work which can deal with "parts" that are made up of "parts". I want to create a table called parts which has a number of fields to do with the parts e.g like part no, description etc... I'm not however how to create the hierarchy structure in the database? For example; A bicycle is made up of a wheels, which consist of tyres and a rim Can anybody help? Thanks
|
|
#3
November 22nd, 2005, 05:58 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Parts Management
Thanks for that looks like I can make it work for my case
"Allen Browne" wrote: Search for: Bill of Materials There's a sample database you can download and convert to your version in this link: http://www.mvps.org/access/modules/mdl0027.htm -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Meak" wrote in message ... i'm a newbie at this database programming. I've looked at some examples but cannot solve this query! I'm trying to create a database for my place of work which can deal with "parts" that are made up of "parts". I want to create a table called parts which has a number of fields to do with the parts e.g like part no, description etc... I'm not however how to create the hierarchy structure in the database? For example; A bicycle is made up of a wheels, which consist of tyres and a rim Can anybody help? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Message divided into parts! | Zrikat | General Discussion | 1 | September 6th, 2005 09:54 PM |
| Matching parts to model numbers | Craig wotdoo | General Discussion | 4 | May 12th, 2005 05:56 AM |
| incorrect totals for parts | jkendrick75 | Setting Up & Running Reports | 2 | January 31st, 2005 02:57 PM |
| using a form parameters to open a report | jkendrick75 | Setting Up & Running Reports | 5 | January 14th, 2005 05:05 PM |
| Wither Open Document Management API? | Terry Menta | General Discussion | 1 | May 21st, 2004 12:14 PM |
Linear Mode
