This is driving me crazy, multiple addresses

[nyguy]

I'm trying to setup this for a small business.

I am creating a table to hold contacts informations. The fields are name, address, city, phone, etc. My problem is that I can have a customer to whom I will be providing services on locations different than the billing address.

My invoices will have to have both the billing address and service address. If they are the same, I will click on an arrow to paste the billing address to the service address area on the invoice. However, if they are not the same, or one of my customers have more than 2, 10 or more locations, how do I create a button or something I can use to add new location?

Am I making any sense? I'm new at this and after 15 days trying and seaching on this forum and internet I came up with nothing. Thank you.

Edited to mention, that when I access a customers account, I will use a portal to display all the services addresses to that customer and from there, create, schedule, etc service invoices.

Edited January 8, 2009 by Guest

[Søren Dyhr]

If they are the same, I will click on an arrow to paste the billing address to the service address area on the invoice.

Why, how are the billing or the first address then entered? They should ideally be stored in an independent table ... how is it done in your stuff?

--sd

billservice.zip

[nyguy]

Hi Søren Dyhr,

The address is first entered on a button "create new customer". I have created another table to hold the service address, I'm lost on how to create a button to add multiple addresses to the same billing customer.

I probably still sound confusing.

[Søren Dyhr]

All right then I changed my template to deal with this aspect too...

--sd

BillingUpdate.zip

[nyguy]

Thanks again,

I'm trying to open your file on layout to understand it, but it's not modifiable.

[Søren Dyhr]

You need to drag it out of the archive before playing with it!

--sd

[nyguy]

I don't know how to thank you enough. You have no idea how frustrating this has been to me. Thank you again.