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?
If you have these two tables:
with possibly many comments for a given customer,
Then you need to put a portal to comments on your customer layout. This will allow you to see all comments for a given customer and you will be able to use the portal's scroll bar to move from comment to comment for that customer.