Table set up

This is an easy one...for anybody but me.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14053-table-set-up.html

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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053
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.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053
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.

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053

--
Rick B



"Frustrated" 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.

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053
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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14053
> 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.