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.