Can I do this?

  • Thread starter Thread starter Seth Meranda
  • Start date Start date
S

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
 
Is there some reason you need to store duplicate data in 2 tables? Normally,
that is a bad idea.
 
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?
 
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
Click to expand...

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.
 
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
 
Back
Top