I have a 'products' table  that I would like to incorporate in a layout that will be used by customers to browse through products in a shop.

 

I would like around 4 records viewable at a time (2 fields - a container for an image and a description field , and then buttons to shift to the next set of records 1-4 , 5-8 ect.

 

like this:

 

 

 

has anyone successfully managed to do something like this?

 

any help would be appreciated

 

thanks

You can use 4 portals and use portal filtering or filter the relationship. Your buttons can run a script that can adjust the starting point of the filter.

Thanks for the reply , and pointing me in the right direction - I had a play around with some sort of filter calc , but have to admit that I just couldn't get my head around it.

 

with regard to the 4 portals - should I set all four portals to the same 'initial row' of 1 (and then the filter calculation will sort out the viewable records), or set them sequentially 1 , 2 , 3 and 4?

 

here's an example of the database, if you would be so kind as to give me an example of a filter calc .

 

thanks

Example_database.zip

I was in the middle of creating a sample file for you when I remembered that Comment had a demo he created a few years ago.

 

http://fmforums.com/forum/topic/71939-getting-more-out-of-filtered-portals-4horizontal-portal

Thanks for finding that - i shall take a look

That works perfectly !

 

Thank you Mr Vodka for pointing me to the file , and thanks to Comment for uploading it