| Managing data block based on outer join [message #352243] |
Mon, 06 October 2008 15:52  |
yuriy_l
Messages: 6
Registered: September 2008
|
Junior Member |
|
|
Hello All,
I have a form which is used for managing dates of study exams. Data structure is organized as follows: exam ids and names are located in table A, table B includes exam date and foreign key exam_id, referencing particular exam in table A. There are situations, when for an exam there is no date (no record) in table B.
On form I should present all the exams and their dates. Thus, I'm using the outer join B on A.
After unsuccessfull tries it seems to me that in such situation I'll not be able to use standard Forms insert/update/delete mechanism.
Is it so?
I'll appriciate any of Your comments/suggestions.
Yuriy.
|
|
|
|
|
|
| Re: Managing data block based on outer join [message #352449 is a reply to message #352279] |
Tue, 07 October 2008 13:43  |
yuriy_l
Messages: 6
Registered: September 2008
|
Junior Member |
|
|
As far as I know, in Master-Detail construction corresponding record(s) from the detail table are shown only when focusing on the referenced master table record. So, I can't use this construction - I need to show all the records at once.
But your second suggestion provided me to a solution - if some exams which are going to be shown on form don't have date records in table B - I'm inserting such empty records in autonomous transaction in PRE-QUERY trigger. So, in such case I have always 1 to 1 relationship on the form, and thus Forms could perform all the DML.
Thanks, Yuriy.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
