Re: Sufficient reason to de-normalize a field?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Earl (brikshoe_at_newsgroups.nospam)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 10:08:33 -0500

Great solution Kevin. Thank you very much.

"Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
news:Ggec$trUEHA.2628@cpmsftngxa10.phx.gbl...
> Hi Earl,
>
> First of all, I would like to confirm my understanding of your issue. From
> your description, I understand that you need to know how to design the
> database structure without redundant data in a senario that payee is
> automatically added into database. If there is any misunderstanding,
please
> feel free to let me know.
>
> Based on my experience, you can also keep your database from redundant
data
> in this case. When adding payee to the database table, we can first check
> for existence in the subordinate table to see if this name has been added.
> If it hasn't been added, add it. The insert procedure returns the ID for
> the payee. Then we use this ID to update the payee's ID in the main table
> and insert the payment transaction into database.
>
> HTH. If anything is unclear, please feel free to reply to the post.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>

Relevant Pages

  • RE: Sufficient reason to de-normalize a field?
    ... I understand that you need to know how to design the ... automatically added into database. ... you can also keep your database from redundant data ... When adding payee to the database table, ...
    (microsoft.public.vb.database)
  • Re: New Record Question
    ... excluding the fact that you are thinking spreadsheet in a relational ... database, you could add this magic button. ... In a spreadsheet is is normal to have a lot of redundant data, ... populating makes the users job a lot easier because they will only be ...
    (microsoft.public.access.gettingstarted)
  • Re: Do I need INDEXes when a UNIQUE has been set?
    ... That really depends on your goal, and how your database implements a UNIQUE ... In SQL Server, this would be redundant, since a unique constraint is ... they help to keep redundant data out of your ...
    (microsoft.public.inetserver.asp.db)
  • Re: Do I need INDEXes when a UNIQUE has been set?
    ... That really depends on your goal, and how your database implements a UNIQUE ... In SQL Server, this would be redundant, since a unique constraint is ... they help to keep redundant data out of your ...
    (microsoft.public.inetserver.asp.db)
  • Re: Help
    ... redundant data. ... without knowing more about the structure of your ... database and what exactly you need to do, it is difficult to provide a ... specific suggestion. ...
    (microsoft.public.access.forms)