Jump to content
Sign in to follow this  
frank929rr

One customer, many addresses, many services

Recommended Posts

I have "Customer" table linked to "Address" by CustID.  No Problem there.  Each customer can have multiple addresses with multiple services.

 

I'm trying to figure out a way to link the "Services" table to the "address" table but here is the issue.

 

I want all the available "services" to show up in a portal in the "address" layout.  I've linked them by using a "address_lineitem" table, since the price is different for each "customer"

 

Is there a way to have that portal of all available services dynamically update if we add a new service or change the name of a service in the "services" table?  

 

Do I have to script it or is there an easier way?  I feel like there should be an easier way, but I'm just not seeing it.

 

Thanks.

 

 

Share this post


Link to post
Share on other sites

You need to figure out the interactions and relationships between the entities in your system first.

Start with basic Entity Relationship modeling... if you have not already done so.

http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model

Sounds like you have Customers, Addresses, and Services

Does a customer have one address or many address?

Does a customer purchase services?

if yes then can the customer purchase the same service multiple times?

How does an address relate to a service?

You'll probably end up with a few join tables to knit things together efficiently.

Build the foundation (database) before the roof (UI).

Share this post


Link to post
Share on other sites

Assuming you have:

 

Customers -< Addresses -< AddressServices >- Services

 

place a portal to AddressServices on a layout of Addresses, and show the Services::Name in the portal (along with fields from AddressServices, such as price).

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.