I am working in a project in which I will have to deliver DataWarehused data from my systems so I need to create on the fly the "un-normalized" or "de-normalized" sets of data from day 1 at the same time that my systems will be working "fully referenced
with its entire data integrity"
What I'm trying to say is that I need a way of working "normally" (the usual way we all programmers work with related tables/entities) and a second way (which is the "spoiled" version: the "un-natural version" for storing data) which will imply carry on
in all of my detail tables the content (the text) of all dropdowwnlists chosen by the end-user.
For this purpose I have the following:
This is well known: Let's say that I have Products and Sections in the Nothwind database. Categories is Foreign Key (FK) of Products.
In my case I will have an extra column in my Products table in order to "STORE BOTH: the CategoryID PLUS CategoryName) ... and the date in which I performed this operation of course.
In my case, if I have a table which has 7 foreign keys then I will create 7 additional columns for storing the "names" chosen by the user in each of the 7 dropdownlists.
In that way I will have what I want ( ... well I really need) to save this redundant data in my tables (I know ... sounds crazy .... I am absolutelly nuts !!!!!)
SO STEPHEN, I need to do this at the time of updating and at the time of Inserting the data
Member
242 Points
480 Posts
Re: Grab data captured on a detail form
Nov 24, 2012 09:31 AM|klca|LINK
Hi Steve,
I am working in a project in which I will have to deliver DataWarehused data from my systems so I need to create on the fly the "un-normalized" or "de-normalized" sets of data from day 1 at the same time that my systems will be working "fully referenced with its entire data integrity"
What I'm trying to say is that I need a way of working "normally" (the usual way we all programmers work with related tables/entities) and a second way (which is the "spoiled" version: the "un-natural version" for storing data) which will imply carry on in all of my detail tables the content (the text) of all dropdowwnlists chosen by the end-user.
For this purpose I have the following:
This is well known: Let's say that I have Products and Sections in the Nothwind database. Categories is Foreign Key (FK) of Products.
In my case I will have an extra column in my Products table in order to "STORE BOTH: the CategoryID PLUS CategoryName) ... and the date in which I performed this operation of course.
In my case, if I have a table which has 7 foreign keys then I will create 7 additional columns for storing the "names" chosen by the user in each of the 7 dropdownlists.
In that way I will have what I want ( ... well I really need) to save this redundant data in my tables (I know ... sounds crazy .... I am absolutelly nuts !!!!!)
SO STEPHEN, I need to do this at the time of updating and at the time of Inserting the data
Carlos N. Porras
(El Salvador)