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.

quite simple in PHP

With FX forge (http://fmwebschool.com)

You enter in your search criteria, how many records to display per page, and 'fx forge' produces clean code with Next / Previous links and code for skip value etc.

Here is the sample code that is needed

if(isset($_POST['skip'])){ $skipSize=$_POST['skip'];}else{$skipSize='0';}

 if(isset($_POST['type'])){ $type=$_POST['type'];}else{$type='';}

you also need:

$search->FMSkipRecords($skipSize);

and finally in your html:

The rest is easy with FX Forge...