We are looking closely at SugarCRM for sales and support.

We support restaurants. Typically there is the corporate account (eg. McDonald's) which has x number of stores. All our tracking and reporting is usually based on the corporate accounts.

BUT we still like to track from a call perspective which stores actually called in. When we create a new case we take the persons name, account name (eg. MacDonald's) and finally what store they are calling from.

We would save the store's phone number, address, name, and a few other details (what tier level of support they have).

The question that I have is we need to create a new table I guess called "Store". The object Account then is linked to the stores in a one-to-many relationship. So we would need an editing tab to create new stores and choose which Account they are linked with ... and then when creating a case ... have a lookup feature that considers the Account that was just selected to lookup the store names that only fit with that Account.

I'm assuming this all can be done with SugarCRM ... but cannot be done with the SugarCRM Studio and will need custom PHP and MySQL development.

Is this true? Are there any modules that can faciliate this without needing to code.

Thanks, Tom