I would like to duplicate a field with another value from another record within the same block. For example, there is a record in a block, which has Daemon Const (supplier name) and dmh55(invoice number). Now when users enters another record, and if he chooses the same supplier as above(Daemon Const), the invoice number should be the same as before(dmh55).
In other words, all the records in a block with same supplier name should have same invoice number. If user tries to enter anything else, it should error. I hope i made sense. Please let me know if anyone has any idea using forms personalization.
we are on R12.1.3 on Linux SLES10.