Hi everyone,
I have created 2 tables named Integration Header and Integration Lines respectively.
The Primary key of the 2 tables is a field named Entry No. which is an Auto Increment integer field. In the Integration Line , I have another field named IntegrationHeaderEntryNo which refers to the field Entry No of the Integration Header (via Table Relation) in order to create a Parent-Child relationship.
I have also created 2 pages of type list part i.e. one for each table.
Then I have created a Card page, showing the 2 list parts as follows;
page 50103 Documents
{
ApplicationArea = All;
Caption = ' Documents';
PageType = Card;
UsageCategory = Administration;
layout
{
area(content)
{
part(IntegrationHdr; IntegrationHdr)
{
ApplicationArea = all;
}
part(IntegrationLine; IntegrationLine)
{
ApplicationArea = all;
Provider = IntegrationHdr;
SubPageLink = HeaderEntryNo = field(bfmt_EntryNo);
}
}
}
}
When I open the page with no data i.e. the 2 tables are empty, it works and I can see the page.
The problem starts after I input at least one record in the header i.e. if the header has at least one record, when I open the page that is showing both List Parts, it crashes and shows the below error;
Some things I tried;
- I created a 'normal' List page (not List Part) with Source Table set to Integration Header and this works perfectly fine.
- I removed the link between the two list parts i.e. removed the Provider and the SubPageLink properties in the lines list part, but still got the same issue
- If I try to run the list part of the integration header by itself, it still throws the error message.
- I tried to run the Integration Lines list part by itself and it works fine.
- Restarted the environment - same issue
- Uninstalled, unpublished & re-published the extension - still same issue.
- Synced the schema upon publishing with Force Schema & Recreate - still same issue.
Basically, if I have at least one record in the integration Header Table, the page crashes as if the page cannot handle displaying the data.
Anyone has any ideas what could be wrong here? Any help would be greatly appreciated.
Thanks in advance!