Home » Developer & Programmer » Forms » Master-detail form and tabs (Form Builder 9.0.4.1.0, Windows XP Professional)
Master-detail form and tabs [message #385435] Mon, 09 February 2009 10:57 Go to next message
scorpio4frenz
Messages: 48
Registered: October 2008
Member
I have a master-detail form. There are several "detail" blocks, each of which is displayed in a separate tab. The problem I'm facing is that when I query something in the master block, the detail block on the same canvas remains blank. It shows the fetched data only when one of the fields in it is clicked or if I click on another tab, and navigate back to the first page again. This is true for all the tabs. There is no error in fetching the data, its just something to do with the display. (possibly keyexe-trigger?)

I'm not able to figure out where to look for the cause of the problem. Any tips are greatly appreciated.
Re: Master-detail form and tabs [message #385456 is a reply to message #385435] Mon, 09 February 2009 14:47 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If the whole "logic" that stands behind the query execution has been done "by default" (i.e. using data block Wizard), everything *should* work properly.

As you have mentioned the KEY-EXEQRY trigger, what (else) did you do so that you have messed up the default behaviour?
Re: Master-detail form and tabs [message #385465 is a reply to message #385456] Mon, 09 February 2009 17:13 Go to previous messageGo to next message
scorpio4frenz
Messages: 48
Registered: October 2008
Member
Littlefoot,

I have created my master-detail in designer and it was working perfectly when all the detail blocks were on the same canvas as the master. Due to the clutter of information, I separated each detail block on a separate tab. I didn't "mess up" anything. All the data is fetched perfectly...there's just a problem with the display.

Turns out it is an issue with Designer and that's how tabs work when created in Designer. I've resolved my problem by writing explicit logic for navigating to each detail block and executing query there.

Re: Master-detail form and tabs [message #385533 is a reply to message #385465] Tue, 10 February 2009 01:04 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I didn't "mess up" anything.
But, you did! You have said that - at first - form worked just fine. When you "did something" (redesigned the layout), it stopped working. (Just kidding!)

Unfortunately, I don't use Designer so I can't tell (from my own experience) why that happened and what should be done in that case.

Fortunately, you have found a solution; I guess that you'd be much more happy if you didn't have to do it manually, but ...
Re: Master-detail form and tabs [message #385631 is a reply to message #385435] Tue, 10 February 2009 05:40 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
I assume designer created a relationship between the two blocks.
What did it set the Coordination properties (deferred and automatic query) of the relationship to?
Re: Master-detail form and tabs [message #385657 is a reply to message #385435] Tue, 10 February 2009 07:31 Go to previous messageGo to next message
scorpio4frenz
Messages: 48
Registered: October 2008
Member
Littlefoot,
I did change the layout, but by merely changing display and placement properties on the detail blocks. I haven't touched any logic and there is no reason for it to behave strange! I did some asking around and people told me that when you create tabs in Designer, the default behavior is that data doesn't appear in detail tab right away..you need to click in there or need to move to another tab and come back.

Cookiemonster,
The relationship between the blocks is basically master-detail...1 master and about 5 detail blocks on separate tabs. I'm sorry to ask a silly question, but where exactly do you look for "coordination properties"?
Re: Master-detail form and tabs [message #385665 is a reply to message #385435] Tue, 10 February 2009 08:03 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
In the property pallette of the relationship found under the relations node of the master block in the object navigator.
Re: Master-detail form and tabs [message #385928 is a reply to message #385665] Wed, 11 February 2009 23:09 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If the only problem you have is that the tabs are not being populated, consider creating a trigger that goes to each subordinate tab and then comes back to the current block. This would probably be the 'when-new-record' trigger of your master block.

David
Previous Topic: Open question on a form navigation best practice
Next Topic: How to kill excel.exe from task manager?
Goto Forum:
  


Current Time: Mon Feb 03 18:09:39 CST 2025