Hi,
I'm trying to patch parent/ child tables in single onselect event, like this
ClearCollect(
colEmployee,
Patch(
Employees,
{Employee:Blank()},
{'FIRST NAME':"Test patch"}
)
);
ClearCollect(
colEmployeeChanges,
Patch(
Employee_Changes,
{Employee_Change:Blank()},
{Employee:First(colEmployee).Employee},
{REQUESTOR:"Test patch"}
)
)
The error is saying that the expected type of argument is record while a guid is supplied instead.
The error refers to this line {Employee:First(colEmployee).Employee},
Employee is lookup column in Employee_Changes tabe to an Employee table.
Could someone please advice id there's a way to convert types or to do something similar to fix the issue.
Thanks!


Report
All responses (
Answers (