Filter Table Control by Logged-In User

A table control can be filtered to display only the records for the logged-in user.  This can be accomplished by adding a WHERE clause for the table control in the Query Wizard with the USERID() function.

Step 1:  In the Page Layout Spreadsheet, select a table control.

Step 2:  In the Data Sources tab, select the appropriate query and open the Query Wizard (Edit…).

Step 3:  In the Query Wizard, add a new WHERE clause containing a formula that restricts the records displayed, for example, only those customer records whose CustomerID is the same as the logged-in User ID.

= USERID()

Step 4:  Build and run your application.

See Also

Common Formula Examples