Auto fill of data

[k.roberts]

I have 2 tables within a database. I wish to compare field 'ID' in
table 'Report' with field 'SchNo' in table Final List, and bring
forward the data from field entitled 'Name' in table Report, into a
field entitled 'SchName' in table Final List if the 2 id numbers match.
How do I go about doing this?

 

[Guest]

You should be able to do this with an Update query if you set the
relationship between the field ID and SchNo - I strongly recommend you back
your data 1st though!!

Sheila

 

[John Vinson]

I have 2 tables within a database. I wish to compare field 'ID' in
table 'Report' with field 'SchNo' in table Final List, and bring
forward the data from field entitled 'Name' in table Report, into a
field entitled 'SchName' in table Final List if the 2 id numbers match.
How do I go about doing this?

Generally - You don't.

Storing data redundantly is NEVER a good idea.

Just create a Query joining [Report] to [Final List] by joining ID to
SchNo, and base your form or report on this query. It is neither
necessary nor good design to store the [Name] in two different places.

John W. Vinson[MVP]