X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Closed TopicStart new topic
> Normalizing A Database, Any Version    
post Dec 8 2003, 06:04 PM

Retired Moderator
Posts: 10,493
Joined: 12-January 01
From: Lexington/Louisville KY USA

I posted this recently in response to another poster's request, and hope that it can help you work through the process of normalizing your table structure.
(Thanks Jerry Dennison for pointing out the need of a PartsPrice table!)
Attached File(s)
Attached File  343208.zip ( 4.3K )Number of downloads: 517
Go to the top of the page
Jerry Dennison
post Dec 9 2003, 11:45 AM

Head Wizard
Posts: 14,857
Joined: 31-January 00
From: South Carolina, USA

It isn't necessary to have both the PartID and PartPriceID FK's in tblOrderLineItems. You need only the PartPriceID. By including both, you've created a circular join.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    5th June 2020 - 01:40 PM