Relationship Issues

I am wondering is it possible to have a parent relationship tied to more than 
one child?  If so, is there a way to resolve the issue?
-- 
Thank You,;
Vince
0
Vince (257)
1/12/2005 2:23:02 AM
pos 14173 articles. 0 followers. Follow

2 Replies
544 Views

Similar Articles

[PageSpeed] 24

Yes it is possible:
Parent = case of 24
Child = 4 Six Packs

Parent = Case of 24
Child = 24 Singles

What issue needs resolving?  This seems like a reasonable condition.

-- 
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the 
newsgroup so that all can share the information



"Vince" <Vince@discussions.microsoft.com> wrote in message 
news:D463C35E-6FF4-4882-BCCB-DFBD1B80BE7B@microsoft.com...
>I am wondering is it possible to have a parent relationship tied to more 
>than
> one child?  If so, is there a way to resolve the issue?
> -- 
> Thank You,;
> Vince 


0
glenn1806 (721)
1/12/2005 2:35:51 AM
Glenn,
Using your scenario, is it possible to link 7-up Child to 7-up Parent, and 
also have Pepsi Child linked to 7-up Parent? In this example there are two 
Childs both linked to the same Parent. Is there a way to see if I am doing 
this, because I believe some items may have accidentally got linked like this 
because of my using the copy button. If I did do this, I want to hopefully be 
able to quickly go through and fix this.
Thank You,
Vince


"Glenn Adams [MVP - Retail Mgmt]" wrote:

> Yes it is possible:
> Parent = case of 24
> Child = 4 Six Packs
> 
> Parent = Case of 24
> Child = 24 Singles
> 
> What issue needs resolving?  This seems like a reasonable condition.
> 
> -- 
> Glenn Adams
> Tiber Creek Consulting
> http://www.tibercreek.com
> glenn@tibercreek.com
> ----------------------------------------------
> Please DO NOT respond to me directly but post all responses here in the 
> newsgroup so that all can share the information
> 
> 
> 
> "Vince" <Vince@discussions.microsoft.com> wrote in message 
> news:D463C35E-6FF4-4882-BCCB-DFBD1B80BE7B@microsoft.com...
> >I am wondering is it possible to have a parent relationship tied to more 
> >than
> > one child?  If so, is there a way to resolve the issue?
> > -- 
> > Thank You,;
> > Vince 
> 
> 
> 
0
Vince (257)
1/13/2005 4:59:09 AM
Reply:

Similar Artilces:

Contract Relationships
Hi, I am trying to create various many-to-many relationships to the Contract entity. One example is linking Contracts and Contacts via an intermediate custom entity called Contract Contact. A Contract can have many Contract Contacts and a Contact can have many Contract Contacts, so this should achieve the many-to-many relationship required. However, when I create my new Contract Contact entity and create a relationship to both Contract and Contact entities I encounter some problems: Firstly, I cannot create a new Contract Contact from a Contract, I don't get the new button, but I can fr...

Issues Settling Credit Card Batches
Hi all, I'm having an issue settling my credit card batches and I'm kind of flying blind here as well. When I settle, all of my batches get an error. The error message I'm receiving is: Error type: Error in batch, Error Record Type: Parameter Record, Error Request Number:2, Error Data Field Number: 10 For background, I'm running POS 2, I've applied SP1, and the CC-related hot-fix. It is integrated with MS Accounting on the backend. Also, just to make sure that I have all of my bases covered config wise, we've set up a merchant account with a company called Payn...

Search Issue
Hi, I have created a form. In the past to search on a client number all I had to do is place the cursor in the field and us "Find and Replace" to search for that client number. Now for some reason when I place my cursor in the field it changes to 0 and stays 0 unless I undo. Any ideas? You did not say what the DataType the field was. "unless I undo" does not say what action was taken. Is it clicking in another field? Does the data display the orignal information? -- KARL DEWEY Build a little - Test a little "Novice2000" wrote: > Hi, > >...

Cannot close the Customer/Vendor Relationships window
One user accidentally opened the Customer/Vendor Relationship in one of the forms in Sale module. She doesn't have access to add or delete a customer or vendor and this prevents her from closing the window. She tried the File->Close but the system is asking if she wanted to add the customer. If she clicks cancel it does not close the window, if she clicks Save it says that she doesn't have the proper security rights. Kindly advise how the user can close the window without using force logoff. Thank you. Yani, Click anywhere on the first line in the grid, then go to Edit &...

Issue passing DataSet as XML from WebService
Hello, I have a WebService that sends a client a DataSet as XML (I use a DataSet.GetXml to get the XML). The DataSet is filled by a DataAdapter in the WebService. The client coverts the XML Back to a DataSet (using StringReader sr = new StringReader(xml); DataSet ds = new DataSet(); ds.ReadXml(sr)). The client then makes changes to this DataSet, and sends the dirty dataset back to the WebService using another GetXml on 'ds'. The WebService re-converts the xml into a DataSet (using a DataSet ds = new DataSet(); ds.ReadXml; )and executes a DataAdapter.Update(ds). The problem is...

relationship
Hi, I'm not sure how to go about this. Can someone point me in the right direction? I have two tables. There are two fields in one table that will match two fields in the other table. When I change the CurrentRevision value in tblRevisions, I want matching record in tblOnTimeDelivery to change the CurrentRevision value also. Here's what I have: tblRevisions *JobNumber *CurrentRevision and other fields tblOnTimeDelivery *JobNumber *CurrentRevision and other fields Thanks for your help, Joel Joel From your description, I'm having a bit of t...

Querying one-to-many relationships
I have two tables, one table with one primary key and one table with several keys: Table 1 NDC GPI 57866660701 1 Table 2 NDC APPL_NO APPL_TYPE_CD 57866660701 074105 2 57866660701 074140 2 57866660701 074207 2 57866660701 074410 2 57866660701 075927 2 57866660701 076494 2 There are a two things I need to do after joining these two tables. One is to find out if there are any records in the second table with different values in the "APPL_TYPE_CD" field for one NDC number. The other is to only return the first record from the second table, not all...

Send as sent folder issue
Is there a way that a user having send as permissions can have the message appear in the original users sent items folder. i.e. Bob sands as Sales but the email shows up in his sent items, therefore Susy cannot see what Bob sent. Try this: http://support.microsoft.com/?kbid=317865 Nue "jschlusser" <jschlusser@discussions.microsoft.com> wrote in message news:6B332D00-8DB4-46E9-9411-8D9558013531@microsoft.com... > Is there a way that a user having send as permissions can have the message > appear in the original users sent items folder. i.e. Bob sands as Sales >...

security issue in notes
we are facing a security issue with notes in MSCRM 3.0 I want some users to be banned from the entity account e.g. So I set a security that they can only see their own accounts (user level) Now I want them to be able to access all contacts. So I set a security so they have full access on contacts. For the notes, I need to give them access to notes so they can attach docs and view all notes on all contacts. Now if this user has advanced find privileges, he will be able to query the notes of ALL accounts in the advanced finds. Anyone experienced this before? any way to restrict that acc...

Calendar issue?
I have a user who's outlook locks up while accepting a meeting request. We have Exchange 5.5 server. He is currently using Office XP (so Outlook 2002) but we also tested by putting his email profile on another PC with outlook 2000 on it (like most of the rest of the users) with the same result. This only happens when dealing with meeting requests. After either outlook is terminated or the request finally goes through (sometimes taking 40-50 minutes), things work pretty much normally. He may have to exit and go back into outlook to work in the calendar OK. It is only for thi...

Entity Customer Relationship
Hi CRMers, Under the Account Entity, there is Relationships. Clicking on Relationships will bring up the Customer Relationship Entiry. In that Entity, Role 1 and Role 2 are picklist with Campaign Partner and Referral. When I tried to edit this entity, Role 1 and Role 2 are of type lookup instead. Can anyone please advice how I can change the values of Role 1 and Role 2? Many thanks in advance. Cheers, Dixon To add new relationship role go to Settings->Relationship Roles and click the new button. You need to have atleast ReadRelationshipRole privilege to see the Relationship Roles ...

Publisher 2003 printing issue #2
Hi, i have msPub 2003 on Vista 64. It seems I can only print one copy of a document with publisher. No problem with other programs. Any idea's would be very appreciated! Erwin Is your printer driver current? Look at the printing preferences in the printer folder. Be certain the default is set at one copy. Publisher is more critical about printer drivers. If you decide to re-install your printer driver, completely remove the driver before you install/reinstall. Is yours a Bluetooth printer? There is a Hotfix. When you use a Bluetooth printer to print multiple documents on a Windo...

Outlook 2007 Indexing issue after upgrade to Windows 7
Since upgrading from Vista to Windows 7 (clean install, upgraded to 64-bit W7) and reinstalling Office 2007, the search function is either slow or does not work at all. 1. Indexing shows complete. 2. I tried repairing my main .pst with scanpst tool. It fixed some errors but did not help. 3. In Search Options the field for "Index messages in these data files:" is blank and does not allow me to add any of my 6 open .pst files. Any ideas? -- Silvia When your pst-files are not listed then it's quite likely that it is because of a mail profile corruption. Re...

Allow customization of relationship view columns in the account
When viewing the "Relationships" section for an account, we cannot change the columns displayed in customizing and are limited to Party 1 Role 1 Party 2 Role 2 which is very limiting. It would be usefult to be able to add additional columns to better descripe the relationships based on fields maintained in the account or contact record. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follo...

Better relationship
Hello Everybody, Let's say I want to link two columns in two different tables. Column from table1 is data source for the column in table2. Should I connect both columns directly? OR PrimaryKey of first table to the relevant column of second column? Which relationship would be better? Thank you, -- Syed Zeeshan Haider -------------------------------------------------------------------------------- Learn about famous muslim names at http://szh.20m.com/learn/aboutnames.html On Sun, 8 Apr 2007 19:31:41 -0500, "Syed Zeeshan Haider" <szhatforumsDELETE@hotpop.SPAMS.com&g...

Login Issue
I have just downloaded Money 2006 and I have been unable to login the first time. I cannot get support until I can supply a product ID number which I cannot get until I log on. Any suggestions? -- Cindy Return it and buy Quicken. .... If you contact support via phone they will give you a product ID. I found this out after spending 1 hour on the phone with them last night. No, I am still unable to login myself. I will be making a purchase of Quicken tonight as I can no longer waste any more time on MS Money. I use Quickbooks at work and prefer the functions anyway. Even if MS Mon...

Google Desktop security issue
I am the admin of a Windows 2003 server network which runs Exchange 2003. I recently installed Google Desktop on my XP pro client. After checking out all of the features I started to notice that the google desktop index feature was starting to retrieve all of the new email from all users in my network, and delivering them to my desktop. Now, the user account I was logged on as, does have admin rights, but that still does not give me access to everyone's email using Outlook. Anyone have any suggestions to why this happened? I have looked everywhere for some info, but have not seen an...

bad relationship?
Ok- so I have created a table for my contacts called Person (with address, phone, etc) and table for Group (with speaker, author, attendee) and then a table for PersonGroup and created a one-to-many between the two. Then I tried to create a Lookup wizard for GroupID from the Person table in order to be able to select the groups that the person are a part of. But yet when I go to forms- nothing. Everything seems to save ok in tables and then I create the form and there's nothing in my drop down. Is this the wrong way to create the tables? I want to be able to fill out my Per...

Office 2010 installation issues
I had a few problems installing this programme and thought I should record the situation. After downloading the file my Laptop running windows 7 RC ( have the final version to install but time is the enemy!!). Installation seemed to run OK but the final screen did not close or indicate any action. Opening a word document saw 2010 run, however, I thought I should reboot to complete the installation. On reboot ALL Office programmes vanished. Documents would not open and there was no way of accessing any Office programmes - including uninstall. I had Office 2007 interop ( I forget t...

OfficeMac- Transferrd to new Computer Issue
Aloha, So all my other programs transferred just fine but Office for Mac ... I have 3 keys ... the old computer is no longer in use yet when i open word I get an error message that i have exceeded my permitted number of uses which i have not. Can anyone help me??? Mahalo & Aloha, John Yeah, when you transferred the program, you also transferred the licence key. So now you've got the same key in use twice :-) Remove the key and use a different one (or: power down the old computer). To remove the key, start the Remove Office tool. Immediately press the "Option" key, an...

How to remove cascading of relationships
Hi, we have developed an application using SDK that import several thousands of entities and activities - using a separate database - into CRM 3.0. After several minutes the application fails on any activity. This is followed by more related errors. During our analysis, we might have identifed the root cause, which seems to be: The cascading levels of the relationships Somewhere in Internet I read about "remove the cascading as much as possible during import". However it was not stated how this can be done in detail. Any help is highly appreciated. Thanks in advance, Fritz ...

customize Customer Relationship & Opportunity Relationship entity?
Hi all, We have tailored MSCRM 3.0 for a client to be more of a Relationship Management System than a CRM system. We have managed to rename the Opportunity entity to Projects. However when it comes to creating a Relationship linking to Account and Contact, the forms in which you do so are till referring to 'Opportunity Relationship'. This is the same case for the 'Customer Relationship' form -I wish to remove all sales-like terms. However, despite Customer Relationship & Opportunity Relationship being referred to as a customizable entity, none of the attributes can be ch...

Syncronising contacts by relationship type
Hi all. I am using CRM 4 with the outlook client. My contacts syncronise perfectly however I also want to see all the contacts for our partners (which are created by another user). I tried to setup the data group options in the CRM add-in in outlook but the contact will not replicate. Please could someone advise how I setup this data group. Basically I need all accounts and contacts that are marked as the relationship type "partner" Thanks Paul -- Posted by NewsLook (Trial Licence) from http://www.ghytred.com/NewsLook/about.aspx ...

Issuing macro in workbook from separate workbook
Hi, Can a macro be issued from another macro in another workbook? i have a macro which copies cell contents, opens another workbook and looks in range for a matching number. i can get as far as using one macro to copy the selection and open the workbook, and another macro to select the sheet required, match the number and paste the contents. However, i cannot issue the other workbook macro from my button. i need to be able to start the other macro with a command or correct input to start it. my thought was [personal.xls]workcell ( but this doesn't work ) Kind Regards, Nigel Nigel, ...

1:N Relationship and auto-Share
Hello, I have an entity called Factory that is organization owned, everyone is the organization is able to view it. I have created a 1:N relationship between Factory and Contacts. I would like to make this a parental relationship or configurable cascading, but I cannot because Contact already has Account as its parent. My goal is to make any contacts associated with a Factory to be automatically shared with everyone in the organization. Does anyone have any ideas how to do this with workflows or scripting or something else? ...