Can I do this?

[Seth Meranda]

I have a two tables created in Access 2000. One table is filled in by a form
on an .asp page. I have a field on the form that I would like duplicated
throughout both tables. Can I set up some sort of a relationship so that the
second table will automatically become updated when the first table is
updated? How do I go about doing this?

Seth

 

[Lynn Trapp]

Is there some reason you need to store duplicate data in 2 tables? Normally,
that is a bad idea.

 

[Seth Meranda]

Why would it be a bad idea?

I am taking the email address out of one table and copying it to another
table which uses it for another purpose (instead of having one large table).
I will be using it for my newsletter script.

Any ideas on how to do this?

 

[John Vinson]

I have a two tables created in Access 2000. One table is filled in by a form
on an .asp page. I have a field on the form that I would like duplicated
throughout both tables. Can I set up some sort of a relationship so that the
second table will automatically become updated when the first table is
updated? How do I go about doing this?

Seth

As Lynn says, This Is A Bad Idea. In a relational database you store
data ONCE, rather than storing it redundantly in two or more tables;
when you need an EMail address, you can create a Query linking to the
table containing it, and base your report on that Query.

 

[Seth Meranda]

Hmmm.... so do you have any tutorials on this? I guess I am sort of a newbie
to access. I have worked a lot with asp and php, but have never focused much
on the database.

-Seth

 

[John Vinson]

Hmmm.... so do you have any tutorials on this? I guess I am sort of a newbie
to access. I have worked a lot with asp and php, but have never focused much
on the database.

There are quite a few books, references, and websites on the subject.
One place to start would be the Access help file, topic "getting
started"; another would be http://support.microsoft.com. Here's one
article that might help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;288949&Product=acc