Hello, New Ref table records are being create...

[Eric_Schwartz]

Hello, New Ref table records are being created without the Parent keys values populated.

The associated parent table fields are defined as LIST and have a formula such as: REF_ROWS(“Invoice”, “JobNo”). What triggers populating the parent key value in the child table Ref field?

Thx

[Aleksi_Alkio]

From where did you trigger the child record? From the inline view with the button “New”?

[Eric_Schwartz]

Correct

[Marc_Dillon]

I think I had this problem before. It might have had something to do with slices? Sorry don’t quite remember.

[Marc_Dillon]

Or rows that didn’t have unique keys

[Aleksi_Alkio]

If your inline view is like gallery view and then you first open that view (from View button), it won’t prefill the ParentID if you open a new record from that view. The case is probably not that if you did it directly from the New button (from inline view).

[Eric_Schwartz]

Hi, The inline views are table views. In each case, users click the ‘New’ button on the inline view to enter a new timesheet etc. The form that appears allows the user to select the appropriate parent record from the dropdown, however this is clearly info that should be populated when the form opens.

[Aleksi_Alkio]

Is this happening always?

[Eric_Schwartz]

@Aleksi_Alkio

Hi Aleksi, Problem resolved. I’ve traced the problem back to the list field definition which was combining data from other fields.

Thanks for your helping me work through this.

[Aleksi_Alkio]

Gotcha. Glad you were able to find the reason!