LinkedIn
Twitter
Hello guys 
I have 3 table
- First table : Tasks
columns:
Task id: Text UNIQUEID() (key)
Task kind : Enum
Task Date: DateTime
employee id : Number
Management : Enum
covenant id: Number
covenant id : Ref
employee id : Ref - Second table : employees
columns:-
employee id : Number (key)
employee name: text
Management : Enum
Related tasks: List - Third table : covenant
columns:-
covenant id: Number (key)
covenant name: text
covenant kind: Enum
employee : text
Management : Enum
Related tasks: List
I have an action button in employees table when I click it adds new records in tasks table based covenant recorded on the employee in [covenant id] in covenant table
But the results only come one record not all records with [covenant id] on [employee id]
This is EXPRESSIONS
LOOKUP(
MAX(
SELECT(
covenant[_ROWNUMBER],
([_THISROW].[employee id] = [employee id] )
)
),
โโ,
โ_ROWNUMBERโ,
โcovenant idโ
)
I hope that my request is clear
and i hope you can find a solution for my problem.
Thank you
