where is the account name in the oppoetunities

[zakcrm]

Hi,

i'm trying to develop a report based on the "opportunities" table. i want the account name on my report but i noticed that the account name does'nt exit in this table.

So where the account name that is used to create an opportunity is stocked in the database ?

Thanks for your help.

[crmbalah]

Hi
create relate filed for account that time the account. Will stored.
You can get the accounts name through this account id, or try to create login hook and save the account name also.

[sugarcane]

you can take a look here to see the relationship between the tables (I assumed you were using CE).

link the opportunities table to the account_opportunities table, then to the accounts table.