Can we see a sample file?
My company won't allow me to upload a file but here are screen shots.
This first image is my "Dashboard." The purpose of this is to see the status of all my jobs. I plugged in a few fake sample records to show what's going on. As you see each Company has an In House Job and and Outsourced Job. They both show in the portals perfectly.
This second image I deleted Nian Database Design's In House Jobs, but doing that made their jobs disappear in Outsourced even though the record is still present in that table. If I delete all the Outsourced jobs I still see the In House Jobs.
Here is how I have my relationships setup. I don't know if this is where I'm making my mistake or not.
I hope this helps.
Is that "x" relationship an actual X(Cartesian) relationship, or does it have multiple criteria?
What table occurrence is the layout based on?
Are the portals filtered?
Thanks for replying again.
It is an actual X(Cartesian) relationship.
The layout is based on it's own table "Dashboard."
Each portal is sorted, but not filtered.
Dashboard is related to only one table occurrence (TO): In House Jobs IH. So of course if you delete the In House record, you no longer have a valid relationship to Client Layout CL, since that's not cartesian, and that affects all the relationships downstream.
I believe what you'll want to do is connect a TO of Outsourced Jobs directly to the Dashboard TO and use that for the portal.
I'd also recommend you look into the "anchor/buoy" data model. It's not the only way to develop, but can be a good approach that helps avoid the kind of trouble you've gotten into.
Thanks Tom. That makes total sense now. I will definitely look into the anchor/buoy data model. I appreciate the help!