Can a portal depend on linked records that are 2 tables away instead of 1 table away?
We have an ORDERS table, and each order is linked to a salesperson in the SALESPERSONS table. We have another table called COMPANIES. Each company is linked to one or more salespersons in the SALESPERSONS table.
Is there any way to have an entire COMPANY log into the portal (for example, the owner of the entire company), and show ALL of the orders that are linked to ALL of the salespersons that are linked to that company?
If you do not have a users' table, you should use our search page extension. It's almost exactly the same as the portal. The main difference is whether or not a users' table exists in your base. Users can edit/update records with the search page extension.
If you would like companies to log in and see all their related records, you can use the Search Page extension. You would just need to add COMPANY as a lookup field in the ORDERS table.