Retrieving/Displaying Account Name with the Account ID

[chad.hutchins]

Hello all,

I have created a custom module (ServiceDates), and I am having some problems with my list view. I have the field account_id in my ServiceDates table as a foreign key, but I need for the account_name to show up in the list view. If that isn't making sense, maybe the inserted image will help out.

I know how to right the SQL to get the Account Name, but I don't know where in the code that belongs.

Thanks,

[chad.hutchins]

To give a more specific question, if I could find where each ServiceDates object is instantiated before the list view is shown or where the query is to grab the list view for the module, I could simply get the account name from the accounts table using the account_id foreign key.

I am new to Sugar, so I am still trying to wrap my head around its design model.

Thanks again,

[eggsurplus]

Chad,

Check out the Contacts module. The exact same thing is done here. You'll see the account name in the list view. Check out Contacts.php, vardefs.php, metadata/lisview_defs.php, and field_array.php and look for all occurrences of account_name.

[chad.hutchins]

Thank you for the response.

I have went through all of the files and made the appropriate changes. I ran the repair routines where necessary, but I am still having issues. Nothing is showing up in my account name list view field.

Any other ideas? What other information could I give you to help understand my situation?

Thanks again,