I tried going to the DBAMP website forceamp.com today and the domain is no longer registered.  Then I called the phone number listed for the company in the phone book (319) 354-3081 and it is dicsonnected.  The support phone number in the application's help menu (319) 383-0200 goes directly to voicemail for sales, support, and accounting.  

Has anyone had contact with this company recently?  

This is way too complex and convoluted to explain all the details, but what my users are asking for is an Account custom field that will display a property of an account that can only be determined by examining a 1:many relationship with another object and those other objects' properties, or by a SQL query.

Here's a simplified version: Say an Account has a 1 to zero-many relationship with a custom object called Muppet__c which has a Name attribute.  
My users want a calculated/read-only Account field that is populated by:
 - if the Account is associated with exactly one Muppet__c where the Name = "Kermit" then the custom field value will be "Frog only"
 - if the Account is associated with multiple Muppet__c and one of them has Name = "Kermit" then the custom field will be "Frog plus others"
 - if the Account is associated with one or more Muppet__c and none of them have Name = "Kermit" then the custom field value will be "others only"
 - if the Account is not associated with any Muppet__c then the custom field value will be "none"
And the custom field must update automatically to reflect changes made in the Account relationship(s) with the Muppet__c object.  

So - here are my questions on the best way to do this:
 - Is it possible to have a custom field (either a pick list or just text) that is read-only in the UI and is populated and updated by a database query?
 - Do I need to create Triggers on every possible method there could be for changing Account-Muppet__c associations to update this custom field?
 - Is there some better way to accomplish this?  

Any advice or recomendations, examples, nudges in the right direction, etc. are greatly appreciated by this under pressure Salesforce newbie.
Thanks

I am very new to Salesforce but I am an experienced developer and understand the principles involved.  I inherited Salesforce dev and admin when the only person at my company who knew anything about it left abruptly, so I am trying to figure it out as quickly as I can. 

I am looking for a recommendation for a tutorial or course, etc. on how to create and test and debug triggers. 
I have managed to set up Eclipse to connect to my Salesforce sandbox, and I have also found how to create & modify triggers in the developer console. 
I have not figured out how to enable any kind of intellisense (if this even exists), step through the trigger code to debug and see what is happening with the objects in the code during execution, or even how to test a trigger other than deploying it and perfoming the action that should activate the trigger.

I have found some very basic tutorials about simple triggers, but nothing on how to set up the Eclipse environment, debug, test, etc. or how to access object hierarchys or database query data inside a trigger. 
If anyone can recommend something for me to watch or a course to attend or anything short of hiring a private consultant/tutor that would be appreciated. 

Thanks

I tried going to the DBAMP website forceamp.com today and the domain is no longer registered.  Then I called the phone number listed for the company in the phone book (319) 354-3081 and it is dicsonnected.  The support phone number in the application's help menu (319) 383-0200 goes directly to voicemail for sales, support, and accounting.  

Has anyone had contact with this company recently?  

This is way too complex and convoluted to explain all the details, but what my users are asking for is an Account custom field that will display a property of an account that can only be determined by examining a 1:many relationship with another object and those other objects' properties, or by a SQL query.

Here's a simplified version: Say an Account has a 1 to zero-many relationship with a custom object called Muppet__c which has a Name attribute.  
My users want a calculated/read-only Account field that is populated by:
 - if the Account is associated with exactly one Muppet__c where the Name = "Kermit" then the custom field value will be "Frog only"
 - if the Account is associated with multiple Muppet__c and one of them has Name = "Kermit" then the custom field will be "Frog plus others"
 - if the Account is associated with one or more Muppet__c and none of them have Name = "Kermit" then the custom field value will be "others only"
 - if the Account is not associated with any Muppet__c then the custom field value will be "none"
And the custom field must update automatically to reflect changes made in the Account relationship(s) with the Muppet__c object.  

So - here are my questions on the best way to do this:
 - Is it possible to have a custom field (either a pick list or just text) that is read-only in the UI and is populated and updated by a database query?
 - Do I need to create Triggers on every possible method there could be for changing Account-Muppet__c associations to update this custom field?
 - Is there some better way to accomplish this?  

Any advice or recomendations, examples, nudges in the right direction, etc. are greatly appreciated by this under pressure Salesforce newbie.
Thanks