Update Query

[conormooney]

in my table 'tbl_herd' it stores records for each animal in a herd. each animal has an Animal ID and Animal Ear Tag Number, it also has a mother and each mother has a DAM ID and a DAM ear Tag Number, every mother also has a record in this table. i want to build a query that will by looking at the DAM ID, take the DAM's ear Tag Number from its original Record and put it into DAM Ear Tag Number?

 

[wizcow]

howdy Conor

If I understand right, you want to insert the 'DAM's ear Tag Number' (from the mothers table)
into the 'CALF's ear Tag Number' (of the calf's table.)

If so...
Build a regular select query, that returns the 'DAM's ear Tag Number' based on the mother's table.

You can make the query look at the form you have open to get the record you want.
In the criteria line under 'DAM's ear Tag Number' enter this...
[forms]![your calf form name]![DAM's ear Tag Number]

Once the query returns the right number, change the query to an update query. in the menu Query>>UpdateQuery
Then fill in the 'Update To' line

The access help has some good stuff on update querys

Good luck
Tom

 

[raskew]

Allen Browne has an excellent article on self-joins.

Might be helpful to take a look:

http://members.iinet.net.au/~allenbrowne/ser-06.html

Bob