Forum Discussion
Customers from a same company different campus
I am trying to build a database to quote my products and i have a challenge managing customer information. Let's say i have a customer working for a university, and this university has several ca...
Here's a slightly different take.
I see two related, but not identical uses for information in this system.
One is the shipping information needed to get products into the right hands.
The other is the marketing information which you might gather in order to target your marketing materials to different audiences.
It seems tempting to want to merge the two, but it might well become too complicated in a single database. Maybe you could think in terms of a marketing application and an operations application.
You could import information from the operations application to support marketing decisions. Or you could implement a marketing tool like SalesForce (although that's possibly on the pricier end of the scale for your needs.)
Thank you very much your answer, however i do not intend to use this database for marketing, i am just wondering how to enter the information on the lab next door, since i do not want to duplicate the fields for campus main address, faculty, buildings, and department. I know that the lab info, which is the last piece of information has to be unique.