Many addresses, one customer
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.