gilcano

Problem with Table Relationships

Discussion created by gilcano on Jan 18, 2015
Latest reply on Jan 21, 2015 by gilcano

Hi all, In the design of my application I have a little bit of trouble or confusion should I said.  I created a TENANT Layout with 3 portals, One to see the Work Orders for that particular Tenant, the second portal is in a tab control with the third one, the second for FOLLOW UPS and the third one for NOTES.  I have no problem with that, the issue is that I would like to include "switch" for "OPEN" or "CLOSED" only.  At one point I would like to see the CLOSED Work Orders but when I load the Layout I would like to see the OPEN Work Orders only as well as their relative OPEN FOLLOW UP's and NOTES.  Here is a picture of my Layout and some schematic of the intended "relationships".  Thanks in advance.

Tenants.PNG

Relations.png

Outcomes