Implementing many-to-many relationships in Oracle Forms 5
Posted on 2000-02-06
What is the best way to implement a many-to-many relationship in Oracle Forms 5?
I'll tell you what I have already tried... Ok so you got 3 tables altogether, relationship is one to many and many to one.
I tried using the built in JOIN and making the intermediary table the child of both other tables, however, although when it comes to populating this child table with values it populates them on the screen at run-time, when I try and save the record it does not insert the values into the database... I have tried everything, the data target property for the table is set to the table. I am so confused as to why it does not insert these values into the database, especially as it displays them in the Form...
Is this a bug in Forms 5???
I also tried implementing it by manually inserting the values into the intermediary table each time the parent primary keys were entered, and although this gives me the functionality I want, I get problems when trying to hide the intermediary table on the screen as I get an error message as it cannot see the items for the intermediary table...
Am I making a mountain out of a mole hill??? Is there a simple way to do this?? Could you send me some sample code for this???
Also I want to add an online Help facility into my menu system for the Forms... What is the best way to do this?? How do you create a form on which you display, say, the contents of the help document and then when the user clicks on the keyword it navigates to the relevant section?? Could you give me some example code for this??
I am writing a Change Request Application for British Telecom as my Final year University project... anyone got any ideas on how to make it an 'A' grade project?? In terms of functionality how can I demonstrate that I can do some real expert stuff in Forms?? Any help would be much appreciated...
Thank you for your help...
Could you email me with all your replies on: email@example.com