Hello Everyone,
I have a table called Applications and a column called SystemUser (lookup to User table). I want to pull up a list of people from the User table and assign a single person to the SystemUser column in the Application table. I have no filters on the Lookup, but I will eventually narrow the list of people to choose from.
When I run the application and edit a record, I select the Magnifying glass to pull up a list of people from the User table; I get the message:
There are no records to display.
What I've done:
- Application table
- User Column of type Lookup
- Related table: User
- Edit form
- Permissions
- Access Type: Global
- Permission to: All options checked
- Roles: Authenticated
- Child Permission
- Permission Name: Webteam List
- Table: SystemUser
- Relationship: cr94c_SystemUser_SystemUser_webapps_Application
- Permissions
I think I got it set up correctly. I'm all ears if there is another way to accomplish my objective.
Thanks,
Ray