jdenver Posted May 14, 2013 Posted May 14, 2013 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
jbante Posted May 14, 2013 Posted May 14, 2013 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.
jdenver Posted May 14, 2013 Author Posted May 14, 2013 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now