Hi Gurus,
i am fairly new to APEX world and recently came across the following requirement.
I have 2 pages 1 and 2. Page 1 is based on table A and page 2 on table B. Tables A, B has primary key - foreign key relationship. Both have identical fields (say name, code, start date, end date).
Now on screen 1 if i enter values for all 4 fields and hit compare button, then the identical fields on page 2 should be populated with the values entered on page 1. Once page 2 fields are populated, there will be a "search" button on page 2 and if user hits it, then APEX should search for any of the matching values for those 4 fields in the underlying table B and return those rows. please assist.
Thanks.