AnsweredAssumed Answered

Navigation button to go to "next"

Question asked by yuichim on Mar 2, 2011
Latest reply on Mar 2, 2011 by yuichim


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!