I am not having much luck with my previous post so I will rephrase and ask again differently.
For example:
Let’s say I have 10 contacts and if I categorise based on name field I will have 10 categories. Is it possible to create a pick list field on this contact person form and for the selected names to be added to this contact category.
So it looks like this
Person A
Person B
Person C
Person B
Person A
Person C
If it is possible can anyone suggest a formula or can anyone suggest alternatives.
Thanks again
Denny
Subject: Is it possible to add category to a category ?
Having read your previous thread and this post, if I understand aright, you have contacts (all of equal status and type) and you want to enable any of these contacts to be associated with any other contacts. You then want to display information about the contacts associated with a given contact, for example in an embedded view. To achieve this, for each association between a “Principle” contact and an “Associate”, you need to store the “Principle” contact identifier (number, name…) in the "Associate"s document (and not, as one might imagine, the reverse). A field “Associate_of” in each Contact document would contain a list of other contacts with whom the person is associated.
You can then build a view detailing all contacts, and categorized by the Associate_of field. Each category of this view will regroup the contacts associated with that person.
You can then embed this view in the main Contact form using the Show Single Category feature to select the category corresponding to the current Contact.
HTH
John
Subject: RE: Is it possible to add category to a category ?
Thanks John
I have been trying to do the reverse that is why it didn’t work like you said.
After following your advice the embedded view shows the associated contacts of the principal. Hurray
Now on to the next challenge…
Denny
Subject: Is it possible to add category to a category ?
I haven’t seen your orginal post, but this one’s not too clear.
Is your ‘should look like this’ example a couple of fields on a form or a categorized column in a view?
If it’s a view, then you’ll never get that since, by definition, all items that share a given value (say ‘Person B’) show up under the category of Person B.
If you’re talking about multiple fields on a form, I’m not sure what you’re trying to accomplish. When you say you want to add some new selection to an existing category list, what do you mean? Are you trying to add user selected values to another field on the form? Where does that other field get it’s values? Is it computed, computed for display, editable, pick list, how’s the list created?
Sorry, but try again.
Doug
Also, I understand the need to re-post when the initial post isn’t going where you want, but it’s probably better to update the initial thread, then post a new link to the existing thread. In that way, the entire discussion stays in one place rather then being split up all over the forum.