Insert new row not visible in Embedded list displayed through relationship

[Manisha17]

Hi Team,

I have created one relationship and displayed that on a form as a embedded list.

But i am unable to get the insert new option. No option available in list control as well to add insert row.

Is there any way to show that?

Relationship:-

Embedded List:-

List control:-

[erik_brostrom]

Unfortunately, this functionality is not able to be used with this type of relationship; it is only available for actual relationship connections (i.e. there is a reference field, like Parent which references the current record).

If your Invoice distribution had a reference to the current record, it would be available via the automatic related list you can add. Would it work with having that relationship on the Invoice Distribution table?

[SaiRaviKiran Ak]

Hi,

You have to create an ACL on "Invoice Accounting" table.

ACL type : Create

[shamil-ibrahim]

I found a solution for this and its working....

Please find the steps below:

1. Remove the relationship list if you have already added on the form.

2. Add the relationship list as a related list in the form.

3. Go to 'List Control' of the related list and check the 'List edit insert row' field

4. Remove the relationship list as related list from the form

5. Add the Relationship back to the form as embedded list.

Please Mark Helpful if this solves your issue.

Thanks

[Bhupen1]

It seems this is more of a workaround. While it does work, there’s an issue that arises when trying to access the "List Control" in the embedded list afterward—the message "Record not found" will be displayed.

For embedded lists, the sys_ui_list_control_embedded table stores the list control, whereas for related lists, it's stored in the sys_ui_list_control table. If the sys_id of the related list's list control (from sys_ui_list_control) that was removed is "xyz", once the related list is removed and the relationship in the embedded list is used, it will attempt to locate sys_ui_list_control_embedded with sys_id "xyz", resulting in the "Record not found" error.