Replace a field in Contacts " Company C " ... with the Account Name in Accounts

💬 General Discussion
1

I created in Contacts a field called companyC, and i like to fill this field with the Account Name in Accounts.

There are some 1500 to do and manually it takes too long. (Copy and Paste), what I do now, workin fine but takes too much time.

Can it be done in Suite CRM ?? and if not ,maybe in MySQL Front, but here i am not familiar how to create a SQL query with select Account
and select field in Contacts.Replace…

I have MySQL Front as as very complex sql writer, but i am a newbie here.

Thanks for any help
William

2

Petrovlis/William again:

I created this in MySQLFront editor, as a beginning…

SELECT
accounts.name
FROM
accounts
INNER JOIN accounts_contacts
ON accounts.id = accounts_contacts.account_id
INNER JOIN contacts_cstm ON accounts_contacts.contact_id =
contacts_cstm.id_c
WHERE
contacts_cstm.companyc_c = " "

NOW i have to add the REPLACE something like replace/updatecompany_c with Account.Name ,

but HOW ???

Thanks for any help.
William