dbTalk Databases Forums  

All data from related table

comp.databases.filemaker comp.databases.filemaker


Discuss All data from related table in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bizouman
 
Posts: n/a

Default All data from related table - 09-23-2009 , 09:33 AM






Hi

I'm trying to reduce some script step and pop-up windows and put thing
into a dialog plug-in.

In a database with table
table1::customer_No=table2::customer_No some time that relation return
multiple data. without using portal, when working in a layout that
display table1 data is it possible to get all related value from a
2nd field table2::contract_No

When using scipt step setVariable [$no; table2::contract_No]
it's only returning the 1st record from the relation.

Is it possible to get all of them... like :

contrat1|contrat2|contrat3 and so on.... with pipe in beetween,
semicolumn or anything else !

Something that will not involve changing layout, new window, or chage
layout.... something that will be instantaneous ??

Thank you

Reply With Quote
  #2  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: All data from related table - 09-23-2009 , 11:56 AM






Bizouman wrote:
Quote:
When using scipt step setVariable [$no; table2::contract_No]
it's only returning the 1st record from the relation.
If you just want to put the multiple related records into a single
variable, you can use the list() function, as in:

setVariable [$no; list(table2::contract_No)]

This assumes you are using FM 9 or 10. For versions 7 or 8, you would
have to define a custom function to do the same thing.

Reply With Quote
  #3  
Old   
Bizouman
 
Posts: n/a

Default Re: All data from related table - 09-23-2009 , 05:06 PM



On 23 sep, 12:56, Howard Schlossberg
<how... (AT) nospam (DOT) fmprosolutions.com> wrote:
Quote:
Bizouman wrote:
When using scipt step setVariable [$no; table2::contract_No]
it's only returning the 1st record from the relation.

If you just want to put the multiple related records into a single
variable, you can use the list() function, as in:

setVariable [$no; list(table2::contract_No)]

This assumes you are using FM 9 or 10. *For versions 7 or 8, you would
have to define a custom function to do the same thing.
Haaa thank you, that was the fonction I was looking for.... I'm new to
version 9/10 so I didn't know that one !!

and to reply to Howard, I already have script step using pop-up window
with portal and user select from the list, but to manage user going
into another window and click something else and all that scripting
for my non-expert skills for my in house solution is getting out of
control, I will use the free plugin Dialog that can make a dialog with
a list, and a selection return, way more easy, also can make that with
1 script line instead of a never ending list of open new windows go to
layout etc etc.

JF

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.