0 Replies Latest reply: Dec 10, 2012 3:18 PM by user1666702 RSS

    Joining tables in a tabular form report

    user1666702
      I have a tabular form report that allows a user to view and update a custom table which has just two columns, customer ID and shipping instructions. However, instead of showing customer ID I would like to do a join behind the scenes with ra_customers (the EBS table that maps customer_id to customer_number) and display customer_number and shipping instructions. Similarly, if a user enters a new row, the APEX report needs to populate customer_id behind the scenes given the customer_number. I am a APEX newbie and am not sure where to go to see an example of this. Any help much appreciated!

      Thanks - Jeff