Hi folks,

I'd appreciate any advice on these questions. I'm trying to stick to using the hosted sugarcrm rather than running on my own server and hacking on the code to do what I need. Am I just not seeing how to do these things or do I really need to consider some hacking?

* How do I create a custom field in say Contacts that links to other Contacts? I'd like to also be able to link between Accounts. The custom field types don't seem to let me do that. Is there a way?

* Say I have some accounts and I'd like to do a search and is and AND or an OR of multiple fields. Is there a way to configure the seach to do that?

* If I have accounts in various cities, and want to just search for those in Seattle. Do I need to add a custom field for the city location in the account, or can I search the billing and shipping addresses?

Thanks!
niall