Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses
M. Soliman
M. Soliman

M. Soliman

  • 4 Questions
  • 6 Answers
  • 0 Best Answers
  • 45 Points
View Profile
  • 0
M. SolimanContributor
Asked: July 17, 20212021-07-17T02:34:09+05:30 2021-07-17T02:34:09+05:30

manually Create Master Detail Form Issue

  • 0

Hi Vinish

i'm trying to create master detail form manually in Oracle Apex 21.1

There is a physical relation between two tables in Database .

1- i have created master region (type : Form)and switch on Primary key Column

2- after that i added a new region(type : IG) , but here in Master Detail property i can not see other region shown in list ...

Please tell me what is missing ,

 

master-detail
  • 2
  • 43
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer
    Advertisement

    2 Answers

    1. Vinish

      Vinish

      • 1 Question
      • 863 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2021-07-17T06:49:36+05:30Added an answer on July 17, 2021 at 6:49 am

      It will show if the proper primary key and foreign key exist in the master and child tables. Please check.

      Or you can just specify the where condition in the IG to filter the records as per the form.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • M. Soliman

        M. Soliman

        • 4 Questions
        • 6 Answers
        • 0 Best Answers
        • 45 Points
        View Profile
        M. Soliman Contributor
        2021-07-17T14:59:53+05:30Replied to answer on July 17, 2021 at 2:59 pm

        thanks , vinish

        here is my sample tables with proper primary key and foreign key referencing to PK

        however Master Detail List in IG didnot show parent region.

         

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Advertisement

    Sidebar

    Ask Question
    Write a Tutorial
    Advertisement

    Recent Blog Posts

    • Vinish

      Oracle LENGTH()

    • Vinish

      Oracle INSTR() Function

    • Vinish

      Oracle INITCAP() Function

    • Vinish

      Oracle Concat

    • Vinish

      Oracle CHR Function

    Advertisement
    Advertisement

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • Image to Base64
    • PL/SQL Beautifier

    Creative Commons License
    This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
    © 2021 OrclQA.Com. All Rights Reserved.
    Privacy Policy - About Us