I'm trying to figure out a way to show all portal entries for all records in one list view area. Is that even possible?
I have multiple items for one customer but i want to see all items from all customers on one area.
It sounds like you just need to create a list view report on your related (items) table directly. If you want to see your customer name there, you should be able to use the existing relationship, but depending on that, you may need a second for a name match.
The "portal entries" are a table (table occurrence) and could already have a layout based on that TO. If not, you can create a layout and choose the TO that is used in the relationship for the portal.
Remember that the portal is a view into that table (TO) but based on the match to narrow the records that are shown in the portal.
Post a screen shot of your layout (showing the portal) for more detailed instructions if needed.
Note that both preceding answers logically assume that you are describing a single table being used as the basisi for any and all portals. If you are discussing portals to different tables that you want to combine in one tabular view of the data, this becomes more complex to do.
Please post screen shot(s) of what you mean, as assumptions are not going to help get you any answers (or good answers!)
customer::ID_pk = item::customer_ID_fk
(for example, or whatever you have as a relationship) - show the screen shot of the relationship. Show the screen shot of the portal (as shown on the layout - in Layout Mode).
I'll chuck out an answer (based on some assumptions of course ).
IF (that is a big if) my preceding assumptions are correct, then the easiest way to do this is to change the Parent/Child relationship to a multi key relationship. You can then toggle between constraining the portal records to only the records related by parent PK or showing all records in the child table (although they will still be related to the parent). You can toggle this either via script or radio button, check box, popup menu choice, etc.
It is fairly easy to setup:
That's it, now when you toggle the state of the trigger field between the two states you've selected (however you chose to toggle it) the portal will toggle between showing you the child records related by the parent ID alone or all child records.
Another option would appear to be to use Portal Filtering. I completely agree that assumptions are dangerous. The OP needs to provide more details.
Retrieving data ...