CANVAS_FORM

2)CREATE ANOTHER CANVAS ,OPEN PROPERTY PALLET OF IT
NAME   ==SCAN
CANVAS TYPE==STACKED
VIEW X POSITION  -100
VIEW Y POSITION-100

===============================================
3)CREATE ANOTHER DATA BLOCK

SELECT * FROM AP_INVOICES_ALL

VENDOR_ID,INVOICE_NUM,INVOICE_AMOUNT,AMOUNT_PAID,DISCOUNT_AMOUNT_TAKEN,INVOICE_DATE

ALONG WITH RELATION OF EXISTING BLOCK OF COOMON COLUMN OF VENDOR_ID OF SCAN CANVAS

4)Place a buttuon in STACKED CANVAS====NAME AND LABLE AS  SCAN
==============================================
WRITE- WHEN BUTTON PRESSED-TRIGGER OF  STACKED CANVAS
====================================

HIDE_VIEW('SCAN');
GO_ITEM('PO_VENDORS.VENDOR_ID');


OPEN KEY NEXT ITEM TRIGGER OF VENDOR_NAME IN CCNA CANVAS
===========================================

IF :PO_VENDORS.VENDOR_NAME IS NOT NULL THEN
SHOW_VIEW('SCAN');
GO_ITEM('AP_INVOICES_ALL.INVOICE_NUM');
ELSE
NEXT_ITEM;
END IF;

5)CREATE ANOTHER DATA BLOCK
===============================(RCV_SHIPMENT_HEADERS)

vendor_id,receipt_num,ship_to_org_id,shipped_date,invoice_date


ALONG WITH RELATION OF EXISTING BLOCK OF COOMON COLUMN OF VENDOR_ID OF SCAN1 CANVAS

CANVAS GETS CREATED NAME IT AS  CCAN

2)CREATE ANOTHER CANVAS ,OPEN PROPERTY PALLET OF IT
NAME   ==SCAN1
CANVAS TYPE==STACKED
VIEW X POSITION  -100
VIEW Y POSITION-100

4)Place a buttuon in STACKED CANVAS====NAME AND LABLE AS  HIDE

HIDE_VIEW('SCAN1');
GO_ITEM('AP_INVOICES_ALL.VENDOR_ID');

OPEN KEY NEXT ITEM TRIGGER OF INVOICE_NUM
===========================================

if :ap_invoices_all.invoice_num is not null then
show_view('SCAN1');
GO_ITEM('RCV_SHIPMENT_HEADERS.RECEIPT_NUM');
ELSE
NEXT_ITEM;
END IF;