TedM Posted March 21, 2006 Posted March 21, 2006 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!
Recommended Posts
This topic is 7091 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 accountSign in
Already have an account? Sign in here.
Sign In Now