PC Review

Thread Tools Rate Thread

Re: Normalizing Tables

Dan Dungan
Posts: n/a
      12th Apr 2012
Hi DuWayne,

Here's a few questions that may help you identify the entities and
their relationships in your process:

1. How experienced are you with normalization concepts?
2. What is the purpose of the database?
3. What are the questions you want this database to answer?
4. Can the same part number be used on several structures?
5. Is there a BOM number?

Tables named Qty or Unit of Measure seem non-normalized to me.

Based on your description, I see two tables

fGroupId Primary Key
fgroup--(The category of each part no

fBomId Primary Key
fGroupId Foreign Key
fpartnoID--given to it by ERP system.
fpartno--(same as fbompart)
fpartdesc--(same asfbomdesc)
ftotqty--(qty used to make shelter)
fbommeas--(unit of measure)

Hope this helps,

Reply With Quote
Tony Toews
Posts: n/a
      12th Apr 2012
On Thu, 12 Apr 2012 20:00:23 GMT, DuWayne O'Neal <(E-Mail Removed)>

>If i create the tables you have listed, how do I get approximatley 45000 parts transfered into the tables?

You can use append queries. Trouble is you'll need one or two for
each of your incoming tables. And maybe one for each of the child
tables if any as, if you used autonumber primary keys, you might need
to renumber the primary key of the child tables.

This can be a large and tedious task.


Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Reply With Quote
Dan Dungan
Posts: n/a
      13th Apr 2012
Hi DuWayne,

You wrote:
> 1. Not to experienced.

I'm still attempting to learn these concepts as well. Have you read
http://support.microsoft.com/kb/100139? It will only take a few
minutes to read.

> 2. I use this database every day to order parts off the BOM, to build theshelters.

How do you use it? What steps do you take to order parts?

> 3. I want to be able to query different category of parts through a form using the Model of the shelter, which is the BOM table name. Each table is named after each shelter Model we build.

I understand you want to query, but what query--what question are you
trying to answer when you look at the table?

> 4. Each of the BOM's dupicate part numbers. *All shelters use cement, so therefore the part number for cement is in each one, same for hundreds ofothe parts in each BOM.
> 5. Again I use Model of shelters to name my tables, such as BCLX10, GIPD03, SUSA20, etc.

> If i create the tables you have listed, how do I get approximatley 45000 parts transfered into the tables?

Are you familiar with append queries, as Tony mentioned?

> Hope you can help further or recommend someone. I will create the tables and will get back with you.
> Thanks again

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tables and Normalizing Data PS Microsoft Access Getting Started 4 19th Dec 2009 12:34 AM
Normalizing Tables and Enter Data in Fields Based on Employee Numb JWeaver Microsoft Access Forms 0 22nd May 2008 09:27 PM
Normalizing tables John Memorex via AccessMonster.com Microsoft Access Forms 1 23rd Sep 2006 08:02 PM
Normalizing Tables Help Needed. =?Utf-8?B?U3lkaW91cw==?= Microsoft Access Database Table Design 2 29th Aug 2006 10:35 AM
Trouble importing and normalizing tables Jeff Microsoft Access Database Table Design 3 9th Dec 2003 02:24 AM




All times are GMT +1. The time now is 05:19 PM.