View several records in a page

PHPMaker General Discussion (PHPMaker)
1

Hi,

I have a table called medication. This table contains

  • MedicationID
  • MedicationName
  • Price
  • TakenTime
  • TakenType

My question is, how can I make the several selected records view in a page?

2

There is no multi-record View page. It depends on what exactly you want to achieve, you may select records in normal List page, and show it in Multi-Column List page with no. of columns = 1, then you can view the selected records in vertical layout.

3

What I want to do is select a few record from the list and print the records.

4

You may, for example,

  1. Use Row_CustomAction server event so you have checkbox to select records,
  2. In your handler for the custom action, get the selected records primary keys, build a WHERE clause and then pass (e.g. by query string) to the Multi-Column List page of a database view created from the same table) with no. of columns = 1 (as suggested in previous post).
  3. In the List page of the view, get the WHERE clause from the query string and use Records_Selecting server event to set the filter.