MS Access update command

Aug 11 2012 6:31 AM

Hello All,
I have a database in MS-Access 2007.
It contains mainly 2 tables 1) Borrower 2) Bill
In borrower borrname and id is saved but id is not in Bill.
Now I have added borr_id column in Bill and I want to set Bill.borr_id=Borrower.id.
I have written
"update bill set borr_id=Borrower.id where borr_name=Borrower.borrname"
But it is not working.
Please help.
Regards,
Zuber Kazi

Answers (2)

database i need output

How can I make sure that duplicate data does not insert while updating