How to show the same portal content on all records on another Table?
I'm not sure if this question has been asked but I can't find the solution anywhere online. Anyway, what I'm trying to accomplish is that I have 2 tables. Table1 for Users, and Table2 for Inventories.
In Table1 (Layout Mode) I created a related Portal that shows the records (Inventories) on Table2. So lets say the Inventory (Portal) has Item1, Item2 and Item3 created by User1. Right now or by default User2 cannot see these Items as if those items only belongs to User1, User2 has to create its own Inventory. But that is not what I want. I want all Users (including newly created Users) to see the exact same Items regardless of which User added those Items. So if User2 updated the inventory, other users will also see that change on their Inventories.
I'm not sure how to accomplish this so I would really appreciate it if you could point me in the right direction or tell me how to do it in detail.