Re: Add a new row based on the condition?

From: joel garry <joel-garry_at_home.com>
Date: Tue, 3 Jun 2008 14:19:29 -0700 (PDT)
Message-ID: <0ae7c39a-c02c-4a71-8c17-b715269929ee@l28g2000prd.googlegroups.com>


On Jun 3, 1:11 am, iher..._at_gmail.com wrote:
> Hello,
>
> I have designed two tables, one for the main information of
> maintenance, and the other for additional information. The additional
> table is used when one column in the main table has the value of 1
> meaning we will send it to other company to repair it. So in the
> additional table we have to record the company name, address, and
> delivery package number, etc. If we can do it ourself, there is then
> no need to use the additional table.
>
> I have been thinking about this approach. Is this the right way? I
> think it might cause the inconsistency of the database and difficulty
> to  maintain the database. But I wonder if there is any alternatives.
> Any suggests? Thank you a lot.

The question becomes, will there be one and only one other company with only one address forever and ever until the end of time? If not, you probably want to store a foreign key rather than "1."

I know one person companies who have more than one shipping address. I work on enterprise software that prepends a company identifier to most everything.

I also know companies that try to fix things themselves, then ship it out if they can't. I also know a company that has mobile mechanics they send to people who've screwed up trying to fix their cars... so, it depends. See Mark's answer.

jg

--
@home.com is bogus.
$10M worth of contrition:  http://www.signonsandiego.com/uniontrib/20080603/news_1b3weiss.html
word: zomel
Received on Tue Jun 03 2008 - 16:19:29 CDT

Original text of this message