Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Table set up

Discussion in 'Information Technology' started by Frustrated, Jul 28, 2006.

Tags:
  1. Frustrated

    Frustrated
    Expand Collapse
    Guest

    This is an easy one...for anybody but me.

    I have two tables and the first is a list of reports, who created the
    report, etc. The second table contains the data sources, key metrics,
    status, etc for each of the reports. Is there a way I can extract the report
    name from table 1 to populate the report name field in the second report?

    Your help is appreciated.
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    Presumably you already have a field in each table which identifies the report
    in question, e.g. ReportID. If so then you don't need to, and should not,
    have a field for the report name in the second table. To duplicate the name
    would constitute redundancy which leaves the door open to update anomalies as
    you could have the same ReportID in a row in each table with different report
    names.

    All you need to do is join the two tables in a query on the ReportID fields
    and return whatever fields from each table you want in the result table.

    Ken Sheridan
    Stafford, England

    "Frustrated" wrote:

    > This is an easy one...for anybody but me.
    >
    > I have two tables and the first is a list of reports, who created the
    > report, etc. The second table contains the data sources, key metrics,
    > status, etc for each of the reports. Is there a way I can extract the report
    > name from table 1 to populate the report name field in the second report?
    >
    > Your help is appreciated.
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    populate the field in the second "report" or "table"?

    If you want to populate the field in the second (related) table, then you
    don't! That would be redundant. If you are trying to store the same piece
    of information in two tables, you are making a mistake (as far as a
    relational database is concerned).

    If the two tables are related to each other, just include both tables in
    your queries. Then, you can pull some fields from one table, and some from
    the other, without the need to store the data in both tables. This is the
    whole point (and beauty) of a relational database.

    Post back if you need more details.

    --
    Rick B



    "Frustrated" <Frustrated@discussions.microsoft.com> wrote in message
    news:12A83748-92FC-4A42-8C60-573DF2327A15@microsoft.com...
    > This is an easy one...for anybody but me.
    >
    > I have two tables and the first is a list of reports, who created the
    > report, etc. The second table contains the data sources, key metrics,
    > status, etc for each of the reports. Is there a way I can extract the
    > report
    > name from table 1 to populate the report name field in the second report?
    >
    > Your help is appreciated.
     
  5. Frustrated

    Frustrated
    Expand Collapse
    Guest

    One more question...so how will I relate the data in the second table to the
    report in the first table? Using the report ID #? I am sorry, but can you
    clarify a bit more for me?

    "Frustrated" wrote:

    > This is an easy one...for anybody but me.
    >
    > I have two tables and the first is a list of reports, who created the
    > report, etc. The second table contains the data sources, key metrics,
    > status, etc for each of the reports. Is there a way I can extract the report
    > name from table 1 to populate the report name field in the second report?
    >
    > Your help is appreciated.
     

Share This Page