Jump to content
Salesforce and other SMB Solutions are coming soon. ×

A portal management question


Recommended Posts

How do you handle this? In my customer file that has a “People Portal” with the fields of First_name, Last_name, Extension and Department. There is also a “Phones Portal” with the fields Phone and Phone type.


What do you do when you have a direct line phone number to someone or a bunch of someone’s? The same is true of emails. You need to be able to show whom the emails pertain to or its just useless information. So what do you do, put People and Phones in the same file? I see that as a possibility, but i’ve never seen it done that way. As a matter of fact i’ve not seen a solution doing what i’m talking about here either. If someone has something like this i’d love to see it, but will be very happy with your ideas.


Thanks for your help,



Link to comment
Share on other sites

I think this is mainly a structural problem rather than an interface problem.


You have to figure out for this particular situation if it makes more sense for Phone to be related to Customer or to Person. I generally think of the Company having a Main Phone, but everyone within that Company as having their own list of Phone numbers.


In cases where there's multiple sites for a Customer, it may make the most sense to relate an Address (Sites) table to Customer, where Main Phone is a field in the Address table. Then for each Person within that Company you select which of the Customer Sites is the Site for that Person. But even in this case, I'd still have Phone related to Person.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use