Creating two portals that are dependent on each other

[etsmarines]

I have 5 tables.

 

Servers

Software

Relationship

Service

Service Defined

 

The Servers table is populated with all the servers in my IT dept

The Software table contains all the software from the servers combined.

The Relationship table shows what software is contained on what servers. Some software is installed on more than one server.

 

The service defined table will have two portals on it. I choose a service from a dropdownlist and then begin to set the servers associated with the service. I want the 2nd portal to show the software that is on that server and when i add another server to the service i want that portal list to add the software that is on that added server as well.

 

I attached the database. If anyone wants to take a look. I have no idea what to do at this point.

[comment]

You haven't explained what is the role of the Service and Service Defined tables and how they are related to the other tables. It sounds like you want to have another many-to-many relationships between services and servers, something like:

 

Services -< ProvidedServices >- Servers - < InstalledSoftware >- Software

 

Once you have that in place, a portal to Software, placed on a layout of Services, will show all software installed on any server associated with the current service (assuming that's what you want).

[LaRetta]

I attached the database. If anyone wants to take a look. 

 

No database attached.  

[Lee Smith]

If you’re having trouble attaching a file, just follow the steps here.