Home » Developer & Programmer » Forms » Detail Block is not updating & showing data
Detail Block is not updating & showing data [message #684126] Thu, 08 April 2021 07:15 Go to next message
falaksheikh
Messages: 1
Registered: April 2021
Junior Member
Dear sir,

I have a form with 2 database blocks and both are viewable in the same canvas. I have defined the relation between Block 1-2. Block-1 is master and type os form & block-2 is child & type is tablure. Now i can enter and save data and when i navigate between records from the first block, then the detail block fetches the correct data based on the relation successfully.

Now, the Problem is when i use F7 from first block & change its date (date cloumn is relation both block)& save it then in block 2 dose not change it. and now in child block data does not show when i run F7 query but in sql data shows .
but the date relation which i created both block does not match.
How to solve this problam if i change data in master block specially in relation cloumn the chiled block also update itself ?

Properties of Relation is
1. Delete behaviour is non isolated.
2. Prevent masterless operation is No
3. Deferred is No
4. Automatic Query is No

Thanks for your suggestion.

Report message to a moderator

Re: Detail Block is not updating & showing data [message #684142 is a reply to message #684126] Thu, 08 April 2021 14:43 Go to previous message
Littlefoot
Messages: 21783
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Detail block contains a date item. Navigate to its "Data properties" and investigate what
- copy value from item
- synchronize with item
properties do. See if setting them to master block's data item helps in your case.

Report message to a moderator

Previous Topic: LOV position
Next Topic: import excel by column mapping using oracle 6i form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 04 14:49:07 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.