This is a no brainer in PHP and MySQL but I'm stumped in FMP.
I am testing the FMP8 demo (as a previous FMP5 user) and looking at running a FMP8 DB mainly via the web instant publisher.
I have a table that could have 1000's of records so I only want the user to see say 50 records at a time i.e. page 1 of 200 with a 'Next' and 'Previous' page feature.
Something tells me this is impossible with FMP and the IWP. I was going to build this web app with PHP and MySQL but I started to lean back to FMP but this seems to be a show stopper.