Hello I am DSteele41
I am working with APEX 5.1 and have built a simple Transactions Database.
I have two Tables in a the Application that I would Like to Create a "FORM"-----> "Two Page Master Detail"
which Calls for Two Tables which I'm using CUSTOMER TABLE and ACCOUNTS TABLE
2 Questions
1.) How do I Implement the "Junction Table" "CUSTOMER_ACCOUNTS" which serves to break up the Many to Many Relationship between Customer and Accounts ?
2.) Can I utilize a Third Table in the Master Detail Form; "TRANSACTIONS" TABLE
I'm looking to Associate which Accounts belong to which Customers AND/ OR which Transactions Belong to each Customer AND/OR which Transactions belong to which Customer
ERD Below with PK FK Relationships (if you need scripts; Please Let me know)
