Update a table based but NOT on Primary Key

[nathanstevenson]

I have a table and a query. The table has contractor name plus 5 dates for each contractor. This has the latest dates.

The query is made up of 4 different tables to draw display the same columsn as the table. THe problem is that the column I need to "compare" by - contractor name is not the primary key in either table.

How do I update the 4 tables from the one, while comparing each of these 4 to contractor?
Thanks!
Nathan

 

[KenReay]

Hi

The fact that it is not the primary key does not change the method of doing the update, but it might mean that you update rows you did not intend to update (if for example the contractor names are not unique)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK