Search results

Yes I know, the essentials of which I've tried to use in my database design - see diagram. However that doesn't really reflect my idea of a Customer Relations Management system. I essentially need something which contains the basics of the template but also has the ability to hold data...

Hello, I am currently in the process of designing a database for a client of mine that really resembles a CRM system. Unfortunately there are a couple of issues that have arisen. The client would like to an example/ a few examples of a CRM system in action to see that this is what he needs...

Thanks! Certainly looks promising... hope to give it a more thorough testing when I'm provided with some more data from my client. I've also renamed the fields that you identified as being a bit slack in your latest post. It's all very much appreciated!!

Is this any better? I've tried to follow what's been said but I think I'm right in saying that the Association Tables should concern the Companies and not the Contacts. After all I'm not looking to have links between the different contacts... its the businesses that are trading with one...

DATABASE DESIGN - HELP REQUIRED I'm trying to design a database for a client of mine who wishes to be able to hold details about particular companies, view their contacts and keep track of all phone calls made and received with these contacts. My client also wishes to be able to identify links...

...so that's a no then! Thanks to all who viewed!

Afternoon! I've just created a table which contains the details of all of the clients for this company. I've moved on to create a form which takes just a small section of the table (client code, client name, web address) and the idea is that the eventual end user can use the form to search for...