Add multiple rows in other table

salehej · 11-16-2021 04:02 AM

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

SkrOYC

Aurelien

Hi @salehej

EDIT : I believed this was a duplicate post, my mistake.

You may want to read this, there are useful tips such as the two @SkrOYC just gave you.