I have created a database containing 2 tables, 1 being 'customers' the other being 'work info'. The relationship is set too one to many.

 

I have a layout displaying the customers info and have set it up so when I click on a customer it opens a new layout showing the work information related to that customer.

 

Ive placed two buttons at the bottom of the 'work information' layout for up and down but I can't work out how to script these to step up and down the found record set being displayed.

 

The 'customers' table contains a 'pk_customers' number field set to auto.

The 'work info' contains a 'pk_job' number field set to auto and a 'fk_customer' number field, linked to the pk_customers field through the relationship.

 

Any help will be appreciated 

When you go from a Customer to the related WorkInfo records, are you doing this with the Go to Related Record script step? If so, is the step set to "Show only related records" and "Match current record only"? If so, you should be able to navigate between WorkInfo records for the same Customer just using Go to Record/Request/Page with "next" and "previous" options.

Thanks for that, just needed a bit of guidance, got myself totally confused, worked though your reply and its all running ok now (I had a few wires crossed). Cheers for the quick response.