Master Detail Relation [message #637860] |
Thu, 28 May 2015 00:55 |
|
Nasir.azeem
Messages: 40 Registered: September 2014 Location: Karachi
|
Member |
|
|
Hi Expert !
I create a form. i am using a table FIN_MTJV_HDR(mater table) & FIN_MTJV_DTL (detail table).
i am using FIN_MTJV_DTL (detail table) 2 times. 1 for debit entries and 2 time for credit entries. 2nd time name is FIN_MTJV_DTL1 (detail table).
and create relation with FIN_MTJV_HDR(mater table) respectively. But when i create record and execute query.
so first record execute all blocks but second record only execute in master block and last FIN_MTJV_DTL1 (detail table for credit entries).
My center block FIN_MTJV_DTL (detail table) not showing any entry after first record. However data available in database.Another side my last block FIN_MTJV_DTL1 perform perfectly.
first & second record snap shot attached
Regard
Nasir Azeem.
[Updated on: Thu, 28 May 2015 00:58] Report message to a moderator
|
|
|
Re: Master Detail Relation [message #637861 is a reply to message #637860] |
Thu, 28 May 2015 01:08 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
How many tables do you really have? Two or three? FIN_MTJV_HDR is one of them - a master table. The next two data blocks are created on ... what? One or two tables? The first detail block ("Debit Account") is based on FIN_MTJV_DTL. What is a base table for the "Credit Account" data block? FIN_MTJV_DTL or FIN_MTJV_DTL1? What does that "1" stand for?
If you used Data block wizard, it created relations, triggers and procedures which make querying possible. As it works for the first queried master record, why wouldn't it work for any subsequent master record?
What happens if you manually navigate to the "Debit Account" data block and execute query in there (for the master record displayed on the screenshot)? Does the record appear in that block? - If not, well, there aren't any detail records there (although you said they are; are all changes committed?). Or, there might be a WHERE clause set in data block's Property palette which prevents records to be displayed.
- If yes, there might be some problems in querying triggers/procedures.If that's the case, try to run a form in debug mode, trace its execution and see what's going on.
|
|
|
|
|
|
|
|
|
|