AnsweredAssumed Answered

One to many to many dynamic portal update

Question asked by frank929rr on Jan 15, 2015
Latest reply on Jan 15, 2015 by frank929rr

Title

One to many to many dynamic portal update

Post

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.

Outcomes