The "Isolation Points" table has a "Type" field that can only contain one value, either "Mechanical" or "Electrical". But on the layout pictured (Safety Clearance) there is a field with check boxes that will allow either or both types to be selected.
I would like to find a way to filter the records shown in the portal based on which isolation type(s) are selected on the "Safety Clearance" layout. If both are checked, then it should show all related records as it does now. But with only one checked, it should hide the type that is not checked.
Here's the tricky part- I don't want the relationship between the Equipment table and Isolation Points table to be altered. That relationship is set up with a joining table (Equip_IsoPnts) and should not ever be modified by the user. The isolation points that go with a given piece of equipment must stay intact, yet still be able to be hidden for that instance of the portal in the current record.
I also need to maintain a record of which child records (isolation points) were selected or hidden for each record of the main layout, i.e. which isolation points were used on a given safety clearance #. As it is now, I can easily look up which points were used. I just want to make sure that whatever method is used to hide certain isolation points from the table maintains the ability to see which ones were/were not selected as opposed to showing all related records.
For a more detailed description of the database, please see my "about me' section and screen shots in the gallery.
Thanks in advance for your help! You guys have been great so far. This forum has been a huge help!