Jump to content

Self-Join portal problem


TedM
 Share

This topic is 5741 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

This topic is 5741 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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