Advertisement

07.20.2007 at 07:39PM PDT, ID: 22711152
[x]
Attachment Details

How to structure this Many to Many relationship in MS CRM 3

Asked by redseatechnologies in CRM Software, Microsoft Dynamics

Tags: relationship, crm

Hi All,

Further to this question -> http:/Q_22703172.html

I am building a CRM database to use for my company which is primarily network services and consulting.  What I want to do is build an asset register, and within that, build a software register.  The idea is that it will look like this;

Client A has these machines
 ServerA is a Server and is installed with Software1 as the OS and Software2 as the primary application, it also does the following Roles and has the following configuration
 ServerB is a Server and is installed with Software1 as the OS and Software3 as the primary application
 Workstation1 is a workstation and is installed with Software4 as the OS and Software5 and Software6 as the primary application.

Etcetera

Now, what I want to also be able to do is be able to see, ok, ClientA has 14 copies of Software1 and 14 copies of Software2, they have 20 copies of Software4 and so on.  This way I can keep a track of serial numbers, licenses, SA expiration, purchase dates, and most importantly, compliance.

So, how am I suppose to structure this sucker?

Currently I have it as follows;

Software is set out as type, so Operating Systems, Applications, Utilities
SoftwareAsset is set out as the actual Application, so Windows 2003 Server, Office 2003, Acrobat 6
Asset is set out as the device, so Server1, and so on.

Can anyone think of a better way than this?  If I can't see how many copies of Windows 2003 Server a customer has, then there is little point in building a separate entity, I could just use picklists.

Thanks in advance

-redStart Free Trial
[+][-]07.27.2007 at 03:59AM PDT, ID: 19581341

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: CRM Software, Microsoft Dynamics
Tags: relationship, crm
Sign Up Now!
Solution Provided By: rfgkev
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.27.2007 at 04:06AM PDT, ID: 19581362

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.28.2007 at 09:02PM PDT, ID: 19586979

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.29.2007 at 12:29AM PDT, ID: 19587299

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32