Update one table when another tabe changes

[8ginga8]

Hi all,

I need a little help. I have two tables one with a bunch of numbers for examle:

table1
-------
1
2
2
3
4
1
2

and another that I want to store on the the distinct numbers in, example:

table 2
-------
1
2
3
4


What I would like to do is to have access update table 2 when a new distinct number is added to table 1.

Is this possible

 

[gol4]

why?
select distinct number from table1

will return the same thing

if you really need it do an append query to table2 based on above.

 

[8ginga8]

i need to make a table with just the distinct numbers so that I can create a many to many relationship with another