I have a layout with 5 portals on it, each showing 3 records, all from the same relationship. Portal one shows records 1-3, portal two shows records 3-4 etc. etc. That gives me a maximum of 18 records that may be showing in the portals at any one time.
I need to be able to set a variable with the total number of portal records that are being shown. E.g., if portals one and two re 'full' that gives me 6 records, if only 2 rows of portal three have data in them then that gives me a total of 8 records being shown via the portals. There may be more than 18 records able to be shown at any one time but I need to know how many are actually being shown via the portals (not the total number of related records)
Short of scripting a visit to each portal row and seeing if it's got any data in it, Is there a 'fast' way to do this?
Basically, it's a product image database. A product type may have any number of images associated with it. A user selects the product type and the portals show the associated product images. If there are more than 18 product images, the user can click a 'next' button which loads the next set of images. Could be another 18 or, say, only the remaining 5. I need to make the 'next' button invisible if there are not any more images to load. Hence the need to count the number of images left to view.
I can calculate the total number of images available for any selected product; it's the 'counting up' of images left to view that I am having a problem with.
Trust this makes sense and thank you as always.