Re: How do i update a table by another table

From: PC Data*** (nospam_at_nospam.spam)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 15:29:37 GMT

You are a real jerk!!! Go crawl back into your hole and slurp on sauerkraut.

Here's the part of my post that you knowingly did not quote ---

Down the road you are going to regret this design of your tables. You are
already seeing the consequences by the difficulty of having to update one
table from another table. Down the road you are going to see loss of data
integrity as well as difficulty in displaying your data in the way you want
on the screen and reporting on your data in the way you want. That being
said, here is my answer to your question.

To minimize your problems, always create the original record in the Master
table and use an autonumber for the primary key. By doing that, you create a
primary key for each record that will never be duplicated. You can then make
a copy of new records in your cell tables. When you copy the record to the
cell tables, be sure to include the primary key from the master table. The
cell table will have its own primary key so you need a field in the cell
table named MasterTablePK to store the primary key value from the master
table. Once the record is in the cell table, your managers can add their
data to the record. When you need to update the master table, create a query
that includes your master table and the cell table. Join the two tables on
the primary key of the master table and the MasterTablePK field in the cell
table. Only include the fields in the master table you need to update in the
query. Change the query to an update query. In each field in the query where
it says Update To, put this expression using your actual field names:
[Celltable].[MyCellTableFieldName]
When you run this query, the fields in the Master Table in the query will be
updated to the values in the equivalent fields in the cell table.

"StopThisAdvertising" <StopThisAdvertising@Data***> wrote in message
news:42453f17$0$44085$5fc3050@dreader2.news.tiscali.nl...
"PC Data***" <nospam@nospam.spam> schreef in bericht
news:xD31e.8843$S46.6008@newsread3.news.atl.earthlink.net...
> Again, I strongly encourage you to reconsider the design of your database
> now since you are still in the process of building your database. If you
> need help with designing the correct table structure for your database,
> contact me at my email address below.
>
> --
> PC Data***

Beware, I bet he wants money for his help.
This guy seems to be just specializing in advertising and job-hunting in the
groups here.
Check out:
http://www.google.com/groups?as_q=contact-me&as_epq=email%20address%20&as_ua
uthors=PC%20Data***%20&as_scoring=d&lr=&hl=nl

Arno R