help needed with simple idea - how do i query sugar?

[nick0]

Hi,
I'm not a programmer per se but i've got ambitions and I'd like to add a simple function to my sugar crm Tasks module.

The short version is, I'm asking how to query Sugar to retrieve addresses for my accounts. (If you know of a good tutorial on the subject that would be awesome too.) Read on if you're curious why and what for...

I'm using the Tasks module for my Warehouse guy to schedule deliveries to customers. So my tasks list looks like this

Checkbox...Account...Date...Time

I want to add a function in the module that takes items he checks in the checkboxes, retrieves the shipping address of the account and passes it to google maps like this:

StreetAddress+City+State+to:StreetAddress+City+Sta te+to:StreetAddress+City+State+to:

This will save my delivery guy about 30 minutes every morning, giving us a cool way to quickly generate directions from delivery address to delivery address with zero effort.

So, I've got the form part under control, getting the list of checked items. If I just sent account names to google, I'd be done right now : )

Help would be appreciated, i'll post updates here as I go.
Thanks, Nick.

[nick0]

here's the variables i;m going to use right?
{SHIPPING_ADDRESS_STREET}
{SHIPPING_ADDRESS_CITY}
{SHIPPING_ADDRESS_STATE}
{SHIPPING_ADDRESS_POSTALCODE}