I Have a list page which is a sub form on a master page. I have it linked via Provider ID to another table. The links work correctly and correct data is being pulled, however the List page sub form is only showing the first record. So for example When I open the page I Should see 5 records but I only see one. In the picture below my table has 3 columns where as when run the page it is only showing one. How can I remove these filters to show all these records.
*This post is locked for comments
You need to check the data as it seems is displays for that record only where the filters are satisfied.
Kindly check the data in table and try to apply filter which you are applying in program and check
Lewis,
Please run the Table for your subpage (from Object Designer) and manually check whether you can see all the desired lines there with the same filters applied.
i.e. No., Document Line No., Label No. and Pack Qty.
Is it a case like you are expecting something but table values are different for any of the linking field which is restricting all records to be displayed.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
Yes the Pack Qty. Is the same on each record I should be expecting to see. I've tried without this and it hasn't changed the result. Why when I run the Page on the object designer it only shows the one record and not all in the table?
you have Pack Qty.=FIELD(Pack Qty.) also in your SubPageLink property which is also applied so check whether this is showing only 1 record.
The filters which I would want applied are "No.", "Document Line No.", "Label No."
what extra filters are applied according to you?
The subpage Link is set up as No.=FIELD(No.),Document Line No.=FIELD(Document Line No.),Label No.=FIELD(Label No.),Pack Qty.=FIELD(Pack Qty.) which is correct for what I need. The only code behind the page is OnNewRecord which I have
recQADefects.RESET;
recQADefects.SETRANGE("No.", "No.");
recQADefects.SETRANGE("Document Line No.", "Document Line No.");
IF recQADefects.FINDLAST THEN
gintLineNo :=
recQADefects."Line No." + 1000
ELSE
gintLineNo := 10000;
"Line No." := gintLineNo;
Quantity := 0;
CLEAR("Defect Code");
CLEAR(gstrReasonDescription);
CLEAR(gintLineNo);
The filter is based on SubPageLink property set on subpage. or check if you have any code in onopenpage etc. on Rec Variable.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
