
Announcements
I have a table (Qualified Users) with 3 columns
1 - Name (Primary)
2 - DeptName (lookup to Departments Table)
3 - UserName (lookup to Users Table)
I want to populate a combo box using UserName as the items in the list. The Items should update based on a filter on a second combo box call cbo (linked to Department Name table)
I inserted a Label to test. The label text is
LookUp('Qualified Users', DeptName.DepartmentName = cbo.Selected.DepartmentName).Name
This works great. When I change cbo values, the lable updates with the Qualified Name
I Insert another combo box and use for Items
Filter('Qualified Approvers',cbo.Selected.DepartmentName = DeptName.DepartmentName).DeptName
This returns records, however, however, the records are blank. I cannot figure out how to display the Name information that should be part of the record.
Regards
Dave