AnsweredAssumed Answered

Many addresses, one customer

Question asked by Stu412 on Dec 16, 2014
Latest reply on Dec 17, 2014 by Stu412

Title

Many addresses, one customer

Post

Hi there, 

I'm working on displaying many addresses for a single customer.  A lot of our customers have multiple sites.

I could create AddressX, CountyX, CityX all in one table where X is a number being the customer site but this would lead to a massive number of columns.

I'd rather create a table where I have columns for clientID and addressID, address details, address type and enter address type as Primary Address, Billing Address, Depot Address etc.

I'd then like to display this information on my customer layout with the Primary details showing by default and perhaps a popover for the other details.

Any help appreciated, thanks.

 

Outcomes