Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Self-Join portal problem

Featured Replies

I'm sure I'm being dumb here but here goes anyway.

I have a large database that has a single table ('Invoices') and the following fields:

invoice_no

account_no

invoice_date

type

input_date

I want to be able to search on any of the fields and display the results in a portal.

I've created a self-join relationship between the 'Invoices' table and a new table occurance called 'Invoices_2'. The relationship is invoice_no = invoice_no

When I do a search the results show fine in a standard list view, but the portal (showing records from Invoices_2 and set to display 25 rows) only displays 2 or 3 records per page.

For instance is I search on 444 in the invoice_no field, all of the records on each page match, i.e. all the records with invoice number 4441 are on the same page, all the records with invoice number 4442 are on another page, etc.

What I want is for it to display all the matching records on the same page.

I'm sure I've got it wrong somewhere but have run out of ideas!

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.