I have 3 Tables - Defects - Departments - Emp...

[Fabian_Weller]

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?

[Aleksi_Alkio]

So… you would like to see the last record (The Department) from your Employee table?

[Fabian_Weller]

@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.