how to make oracle apex wizard steps with multiple related tables?

Question

In Oracle Apex, I have some related tables i.e:

**Person Table**
Id
Name

**Person_Contact Table**
Id
PersonFK
Tel
Address


**Person_Account Table**
Id
PersonFK
BankName
AccountNumber

these are 1-to-1 tables and PersonFK is the Foreign Key. Now, I want to create a wizard with 3 steps. how can I do this?

should I define 3 tables with 1-to-1 relation (like above) or create just one big table?

and

what is the best practice in Oracle Apex (in wizard steps forms) for this purpose?

There seems to be two unrelated questions here, one about data model design and one about building a wizard-type interface in Apex. — Jeffrey Kemp, Nov 27 '15 at 03:51

score 0 · Answer 1 · edited May 23 '17 at 12:23

0

If you are sure that all three tables will remain have common attributes then the option of single table is fine. More detail can be find here

edited May 23 '17 at 12:23

Community

answered Nov 26 '15 at 07:33

Muhammad Muazzam

1 Answers1