Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Stepping up/down a found record set ?


This topic is 4210 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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 

Posted

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.

Posted

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.

This topic is 4210 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.