| Master_Detail Problem [message #577229] |
Wed, 13 February 2013 10:36  |
 |
baighanif
Messages: 1
Registered: November 2012
Location: Faisalabad
|
Junior Member |
|
|
Hello dears,
I have created a master detail form. In Master block, i have enter voucher date and created its relation with detail block.
Now, after saving any voucher. if the user wants to change voucher date, the date is changed in the table associated with master block but does not changed in detail block.
Please any body help me.
I will be thank full for this act of kindness.
Hanif Baig
|
|
|
|
| Re: Master_Detail Problem [message #577257 is a reply to message #577229] |
Wed, 13 February 2013 15:17  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Why do you think it should change?
How are these two tables (master - detail) related? What column(s) make a foreign key? Does it contain a date column? If so, then changing date value in master should change date in detail. However, that sounds rather unlikely - I, somehow, don't think that you chose a date column to be a foreign key. That job is usually done by some "ID" columns, not dates.
If that's so, I suspect that your model might be wrong. Why would you want to keep the same information (date value) in both master AND detail tables? Master is enough; detail can always see it by the means of joining it with the master table using its foreign key constraint column(s).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
