It's a pretty common scenario -- we'd like to print mailing labels addressed to individuals at their workplaces. For example,
UC Santa Cruz
1156 High Street
Santa Cruz, CA 95064
What is the best practice for doing this in Civi? We could just put the organization name in "Street Address", and move the "real" address lines down into "Supplemental Address" fields. In fact, this is what we do -- but it doesn't seem quite right for a couple reasons:
- In Civi's database schema, the "street_address" column is described as Concatenation of all routable street address components (prefix, street number, street name, suffix, unit number OR P.O. Box). The organization name doesn't seem to belong there, really.
- This is a relational database, so why are we storing the organization name twice (once in the org's own record and once in the employee's address?) There should be a more elegant way to handle this.
Other CRMs include a special "Company" address field, distinct from the "Street Address" field, but again this would be duplicative.