Navigation button to go to "next" & "previous" related record?
Hi. I am creating an invoicing solution that creates multiple invoices depending on how many times a client want to split the payment.
I have an "Order" table which has all the products and prices then a button creates a related record (invoices) by inserting an "order id" to the "foreign key order id" field in the invoice table. There is a relation ship by Order-ID(Order table) and kf-OrderID(Invoice table).
From Order layout, you are able to see all the invoices because there is a portal showing all the invoices and a button to go to the related record using Invoice layout.
What I would like to do is to be able to have a button and a script to go back and forth on all the invoices related to that order.
Ex: Previous Invoice - Invoice 2 of 3 - Next Invoice
Any help much appreciated!