NetTalk Central

Author Topic: Table relationship in NT14.00  (Read 2760 times)

Richard I

  • Sr. Member
  • ****
  • Posts: 399
    • View Profile
    • Email
Table relationship in NT14.00
« on: August 25, 2023, 02:47:55 AM »
Hi
I have a table relationship :
Browse Invoice and Browse Line items  with Lineitems on the Browse Invoice page "Right"
as in examples.

The issue is:
when selecting a row field in the Invoice column I expect the response to be focused on the corresponding line item, as  happens in my app with  NT 12.62 and in the Themer example

Compiling and running the same app and Dct in NT 14 however, opens the Update Invoice Popup first and when this is closed the intended Line item is in focus.

I was able to comment out the line p_web precall and that stopped the Update and allowed the application to run as I want, but unfortunately this also prevented a browse insert

The query is:
Why is the Invoice Update opening first in NT 14 ?

Many thanks
Richard

 
« Last Edit: August 25, 2023, 08:34:52 PM by Richard I »

Richard I

  • Sr. Member
  • ****
  • Posts: 399
    • View Profile
    • Email
Re:SOLVED Table relationship in NT14.00
« Reply #1 on: August 26, 2023, 09:06:43 PM »
Hello
Pleased to advise I have solved my problem-
In the WebServer Properties -> Settings -> defaults ->

Row Clicks to "OFF"

Now, The update Browse Popup does not appear and the related line item is selected.
To add edit or delete
The browse Buttons do that OK
Simple - but I do wish these new  settings could be referred to somewhere.....
Cheers
Richard




Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Table relationship in NT14.00
« Reply #2 on: August 26, 2023, 11:07:07 PM »
Hi Richard,

this is not a new setting though, it's been there for years.
Sounds like yours was set to update on a single click?
I recommend setting it to double-click, not to "off".

Cheers
Bruce