Incompatible type: the 'Request Lookup' column in the data source you're updating expects a 'Record' type and you're using a 'text' type.

[DanielMat]

Creating this new post, if anyone had encountered such error....

Two Data Verse tables (New Request & Request Details)

I have New form to create new request, i added these two edit forms on this New form screen "New Request" & "Request Details" are two tables with one to many relation and with "+" user should be able to add more items(to "Request details" table) to the same request.

I'm storing the child records in collection, before saving form

If(
    Form1.Mode = FormMode.New,
    Collect(
        requestdetailcol,
        Form2.Updates
    );
    ResetForm(Form2)
)

New Form screen:

data to both forms will be entered at the same time and saved.

in this case, i will not have an "ID" of the parent form(form1)until the form is saved,so how the look up column("Request LookUp") in the request details table will get the ID from the New Request table?

 and on success property of the form1(parent), i have this code below, trying to get the last submitted record and replace look up column value with last submitted id.

it is is giving this error:

Incompatible type: the 'Request Lookup' column in the data source you're updating expects a 'Record' type and you're using a 'text' type.

On Success Property code:

if(
    Form1.Mode = FormMode.New,
    Patch(
        'Request Details',
        UpdateIf(requestdetailcol,true,{'Request LookUp':Form1.LastSubmit.ID}
    )
);
Clear(requestdetailcol));

Will this work in with Data Verse? or is there any other way to get parent ID to child table lookup?

Thanks in advance....

[Drrickryp]

@DanielMat 

The Parent form must be saved first.  I suggest that you use two forms.  Hide the child form and unhide it once the parent form is successfully submitted.  You can use a context variable in my example (var) as the visible property of the child form and 

UpdateContext(var:true}) in the OnSuccess property of the parent form.