All Collections
General Questions
Use Case Examples
My table has a field for users that is 'lookup', not a linked record.
My table has a field for users that is 'lookup', not a linked record.

I'm looking at the portal but I don't have a linked records field, just a lookup field. Which should I use?

Updated over a week ago

Similar questions

  • 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?

The answer

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.

Did this answer your question?