Display the next related record from another table
I guess this is kind of basic but i can't figure out how to do it, so I have to ask for some help. This is my first table with the main records:
When the "New Comment" button is clicked you're taken to table two and the customer number is copied to the customer number field to add a comment related to this customer. But if there is more than one comment on the customer I want to be able to easily go through the comments with the Next/Previous buttons in table one. Any suggestions on how the script for the "Next" button should look like?