AnsweredAssumed Answered

Relationship Troubles

Question asked by JasonVaughan on Dec 29, 2013
Latest reply on Dec 30, 2013 by philmodjunk


Relationship Troubles


     This should be very easy...

     I have a number of tables, such as Purchase Orders, Invoices, returns etc. I am creating a main layout where I can see key summary information, such as under the Purchase Orders section, a list of all open purchase orders. Under ToDo, a list of open ToDo items. 

     The layout being used is based on the Admin Table, which mainly contains container fields for the various logos etc. In order to have a portals displayed on this page (showing Open Purchase Orders) I created a Global field (Admin_PO_Open) under Admin table and set the value to Open. Next I create a Relationship from Purchase:Purchase_Status to Admin:Admin_PO_Open. 

     The problem is that when I select a portal, it tells me there are "No Related Tables". What am I missing??? All I am trying to do is show a list of open POs.