I have 3 Tables - Defects - Departments - Employee
In the Defects Form I ask for the Department (Ref) of the Employee and for the Name (Ref) of the Employee.
I made it so, that when I choose a Department, Only the Employees of that Department are shown.
When I need to create a new Employee, it should give me the Department I choose before.
I thought it would be just
=ANY(SELECT(Departments[Key] , [_THISROW].[Department] = [Key])) But it doesnโt work.
Any ideas?
Soโฆ you would like to see the last record (The Department) from your Employee table?
@Aleksi_Alkio I want to see the Department I choose in the Defects Table. Usually the last record would be right. But only when I create a new entry. Not when I edit an existing entry.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |