One to many to many dynamic portal update
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.