Updating a field when another is populated.

[Guest]

Hi,
I have a Form that is used to update customer information and I currently
have a button that runs an update query, that looks up the account number and
update the form but it updates all the records in the table. What I would
like to do is add a after update function on the [Customer Acct:] field that
will populate the Customer Name on the form and update the Table. The
information for the customer comes from a Oracle link
[Corp_customer_Acct].[customer_name].
I hope that someone can please help with this.
Thank in advance

 

[pietlinden]

sounds like you're running an update query without any criteria
defined. What happens if you turn the update query into a select?
Does it return all the rows in the table?

post your SQL

 

[Raj]

I am off for the until Tuesday but I will post the SQL the first thing
Tuesday morning..

 

[Guest]

Here is the SQL
UPDATE [MRA Master] INNER JOIN CORP_CUSTOMER_ACCT ON [MRA Master].[Account
Number] = CORP_CUSTOMER_ACCT.CUSTOMER_ACCT_ID SET [MRA Master].[Customer
Name] = CORP_CUSTOMER_ACCT!CUSTOMER_NAME;

Thanks