linking tables

I am a novice with access...

How can i setup a link between tables so that if i add a new entry into
field1 in table1, a new record in table2 is created. Field1 in table2 will
then contain the data as in feild1 table1 - however in table2 duplicates
within field1 will not be allowed.

Index Table 2 Field 1 with No Duplicates. Create a form for Table 1 and
define an event After Update to append the data to Table 1 Field 1.
--
http://panjas.org http://www.linkedin.com/in/spanja

If the reply is helpful or is the answer, click Yes next to
Was this post helpful to you?
and / or
Did this post answer the question?


"Keith Rathband" wrote:

I am a novice with access...

How can i setup a link between tables so that if i add a new entry into
field1 in table1, a new record in table2 is created. Field1 in table2 will
then contain the data as in feild1 table1 - however in table2 duplicates
within field1 will not be allowed.

On Fri, 19 Sep 2008 15:39:07 +0100, "Keith Rathband"
wrote:

I am a novice with access...

How can i setup a link between tables so that if i add a new entry into
field1 in table1, a new record in table2 is created. Field1 in table2 will
then contain the data as in feild1 table1 - however in table2 duplicates
within field1 will not be allowed.


You may be describing a 1-1 relationship, which may not be what you
want. Or, your design is going to store duplicate data, which is
probably also not what you want. In either case, it probably isn't
good database design.

If you would like more help, please post a description of what you
actually want to do.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com