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
Loading
Zuber KaziPosted Oct 5, 2012, 2:24 AM
Kirtan PatelPosted Aug 11, 2012, 7:03 AM
UPDATE b_instance SET b_instance.borr_id = bor.id from bill b_instance JOIN Borrower bor ON b_instance.borr_name = bor. borrname;