Hi, New to access:

I have created two tables tblprospects and tblleads,
Both has customer column from tblcustomer, tblprospect has a column called status:
What I need is when the same from tblprospect:customer is added in tblleads, I need the status field to update a value from tblstatus.
Thanks in advance