records from 2 tables shown in 1 page

MGoosenMGoosen Member Posts: 10
Hello everyone,

Can anyone tell me if it is possible to make a temporary page with records from 2 different tables? And if so, how to do this? If it is not possible to do this, does anyone have a good idea too get records from 2 different tables into 1 page.

My best idea is to use a temporary page or table, but I don't have any excerience with this, so all the information is welcome.

Answers

  • ShaiHuludShaiHulud Member Posts: 133
    The page wouldn't be temporary, just the records you show.

    If you want to show all the records from 2 tables in a single list, then it would be good idea to insert them into a temporary table, that has all the fields you want shown.

    If you don't need to show all the records together in a single list, then you could make a page with 2 sub-pages, one for each table, showing only its records.

    How similar is the table structure? Are there many fields that are unique to just one table? Do you want all the fields from both tables shown?
    Arturas Kulsinskas
    NaviLogic

    All opinions expressed are my own and are not reflective of my employer
  • rxqrxqrxq_zydrxqrxqrxq_zyd Member Posts: 5
    maybe you can refer to sales Order , Page 42
  • MGoosenMGoosen Member Posts: 10
    The tables have the same fields and structure and not all the records need to be shown.
Sign In or Register to comment.