none
related element does not display all records RRS feed

  • Question

  • I have a related element in a view that works perfect with 50 records but when there are 200, even with the scroll, does not show all. Any suggestion?

    Thanks in advance.

    Tuesday, November 29, 2016 7:57 PM

All replies

  • Do you mean you are using a query when you say "view"? What is the SQL for the query? You could be using the wrong join between the tables. An INNER join would show only records where the related fields match in both tables.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, November 29, 2016 8:45 PM
  • Hi rcastellet,

    Did you develop with Access desktop or Access web app?

    >> I have a related element in a view that works perfect with 50 records but when there are 200, even with the scroll, does not show all.

    Could you share us a screenshot about your view? What is your source data and how did you show them in view?

    Best Regards,

    Edward


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, November 30, 2016 5:20 AM