Re: Related Fields in a Listbox (Manual Relations)

2018-11-18 Thread Arnaud de Montard via 4D_Tech

> Le 16 nov. 2018 à 20:36, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Actually, "ok" and "better" are reversed in the examples.  More efficient to 
> let the Automatic Relations do the work.

Yes, I was surprised when I read  ;-) 

Sannyasin, 
• using on display detail will call the server every time a record is displayed 
and will result in a very slow list (not to say insupportable if you access 
server through WAN)
• using SET AUTOMATIC RELATIONS, lines content are calculated on server, much 
better 

-- 
Arnaud de Montard 





**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Related Fields in a Listbox (Manual Relations)

2018-11-16 Thread Keith Culotta via 4D_Tech
Actually, "ok" and "better" are reversed in the examples.  More efficient to 
let the Automatic Relations do the work.

Keith - CDI

> On Nov 16, 2018, at 1:26 PM, Sannyasin Siddhanathaswami via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks. Just what I needed!
> 
> Sannyasin Siddhanathaswami
> On Nov 16, 2018, 9:09 AM -1000, Keith Culotta via 4D_Tech 
> <4d_tech@lists.4d.com>, wrote:
> These have worked:
> 
> // ok
> GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays
> SET AUTOMATIC RELATIONS(True;$m)
> 
> 
> // better
> : (Form event=On Display Detail) // in the listbox method
> RELATE ONE([many]linkField)
> 
> Keith - CDI
> 
> On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Aloha all,
> 
> Is there a simple way to include related field (with Manual relations) in a 
> current selection listbox in v17?
> 
> Not sure why I haven’t done this before with listboxes.
> 
> Sannyasin Siddhanathaswami
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Related Fields in a Listbox (Manual Relations)

2018-11-16 Thread Sannyasin Siddhanathaswami via 4D_Tech
Thanks. Just what I needed!

Sannyasin Siddhanathaswami
On Nov 16, 2018, 9:09 AM -1000, Keith Culotta via 4D_Tech 
<4d_tech@lists.4d.com>, wrote:
These have worked:

// ok
GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays
SET AUTOMATIC RELATIONS(True;$m)


// better
: (Form event=On Display Detail) // in the listbox method
RELATE ONE([many]linkField)

Keith - CDI

On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech 
<4d_tech@lists.4d.com> wrote:

Aloha all,

Is there a simple way to include related field (with Manual relations) in a 
current selection listbox in v17?

Not sure why I haven’t done this before with listboxes.

Sannyasin Siddhanathaswami

**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Related Fields in a Listbox (Manual Relations)

2018-11-16 Thread Keith Culotta via 4D_Tech
These have worked:

  // ok
GET AUTOMATIC RELATIONS($o;$m)  // before the listbox displays
SET AUTOMATIC RELATIONS(True;$m)


  // better
: (Form event=On Display Detail)  // in the listbox method
   RELATE ONE([many]linkField)

Keith - CDI

> On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Aloha all,
> 
> Is there a simple way to include related field (with Manual relations) in a 
> current selection listbox in v17?
> 
> Not sure why I haven’t done this before with listboxes.
> 
> Sannyasin Siddhanathaswami 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Related Fields in a Listbox (Manual Relations)

2018-11-16 Thread Sannyasin Siddhanathaswami via 4D_Tech
Aloha all,

Is there a simple way to include related field (with Manual relations) in a 
current selection listbox in v17?

Not sure why I haven’t done this before with listboxes.

Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**