APEX

Hi all

Oracle Apex is proving to be the undoing of me as i find the Program really confusing and so i need help with my current situation.

I am trying to create a database for an equine advertising website.

Basically I have a supertable called ADVERTISEMENT

I also have 6 subtables HORSES, EQUIPMENT, HORSE_BOXES, PRODUCTS, PROPERTY and SERVICES

I am having a terrible time trying to implement this. I have tried creating supertypes and subtypes but I found that I wasnt able to implement forms from these types

I tried to Just create them normally as tables seperate tables (Primary key from ADVERTISEMENT being the foreign key in the HORSES, EQUIPMENT, HORSE_BOXES, PRODUCTS, PROPERTY and SERVICES) but again i found it difficult as the foreign key index would not copy the primary key.

I would just like a little help to prevent me going any greyer than i already am.


Thanks very much
Michael Oakman