Groups > comp.databases.filemaker > #2585

Re: Dynamic ( nested) value list

Path	csiph.com!aioe.org!.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Dynamic ( nested) value list
Date	Mon, 07 Mar 2016 13:59:17 +1300
Organization	Aioe.org NNTP Server
Lines	36
Message-ID	<070320161359178430%HelpfulHarry@BusyWorking.com> (permalink)
References	<dff63d83-8e99-46ba-9193-ccb07a66aecd@googlegroups.com> <030320161837322485%HelpfulHarry@BusyWorking.com> <12c2e85c-70e6-4492-821f-a9bfaa946d6d@googlegroups.com> <040320161822264078%HelpfulHarry@BusyWorking.com> <147fae8c-b051-4c51-861a-d29a70b077f9@googlegroups.com> <050320161003162488%HelpfulHarry@BusyWorking.com> <911b3405-279b-4410-a5b5-5a7e38c173c0@googlegroups.com>
NNTP-Posting-Host	LHY5wK/kBZpOM3iKUINEVQ.user.gioia.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Thoth/1.8.4 (Carbon/OS X)
X-Notice	Filtered by postfilter v. 0.8.2
X-Face	vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref	csiph.com comp.databases.filemaker:2585

Show key headers only | View raw

In article <911b3405-279b-4410-a5b5-5a7e38c173c0@googlegroups.com>,
Mushabab Al-Murayeh <malmurayeh@gmail.com> wrote:
> > 
> > Since the number of Class, Size, etc. varies, there's no way I can
> > calculate how many records are needed. At worst you need 15 Category x
> > 6 Class x 10 Size x 7 Size ... 6300 records.
> > 
> > You can't ever update them separately since they all need to be linked
> > upwards and downwards through the separate tables - every time you add
> > a new "Class" record, you will have to link / add Category records for
> > the new Class, link / add Size records for the new Class, link / add
> > Colour records for the new Class.
> > 
> > If you keep them in separate Tables, then to achieve the dynamic pop-up
> > menus will mean creating new fields which just copy the related data
> > from the sub-Tables to the parent or child records anyway (every Size
> > records has to know every Class record that uses it, or every Colour
> > record it uses), which means the overall filesize will balloon and
> > likely be bigger than having them in one Table.
> > 
> > Helpful Harry   :o)
> 
> Great ! now you know my problem :)
> 
> Would you please provide a demo example ? and explain briefly .Thank you

It'll take a while to work this out and type it up into a message as a
coherent explanation.

Even if you keep the multiple nested Tables approach, it's probably
better to decrease the number of Tables, even if it means increasing
the number of options in some of them (e.g. instead of separate Size
and Colour Tables, it might be easier to have a combined Size-Colour
Table).

Helpful Harry  :o)

Thread

Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-01 10:14 -0800
  Re: Dynamic ( nested) value list Los_Indios <losindios.m@gmail.com> - 2016-03-01 17:49 -0800
    Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-05 03:13 -0800
  Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-03-03 18:37 +1300
    Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-03 04:22 -0800
      Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-03-04 18:22 +1300
        Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-04 10:35 -0800
          Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-03-05 10:03 +1300
            Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-04 20:10 -0800
              Re: Dynamic ( nested) value list ursus <ursus.kirk@gmail.com> - 2016-03-05 20:46 +0100
              Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-03-07 13:59 +1300
  Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-03-08 18:56 +1300
    Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-08 02:54 -0800
      Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-03-09 18:43 +1300
        Re: Dynamic ( nested) value list dempson@actrix.gen.nz (David Empson) - 2016-03-09 21:13 +1300
          Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-10 13:41 -0800
          Re: Dynamic ( nested) value list Thibaud Taudin Chabot <tchabot@hccnet.nl> - 2016-03-11 11:22 +0100
            Re: Dynamic ( nested) value list ursus <ursus.kirk@gmail.com> - 2016-03-11 19:22 +0100
              Re: Dynamic ( nested) value list Thibaud Taudin Chabot <tchabot@hccnet.nl> - 2016-03-12 16:11 +0100
        Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-03-10 13:40 -0800
        Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-04-06 09:41 -0700
          Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-04-07 08:48 +1200
            Re: Dynamic ( nested) value list Mushabab Al-Murayeh <malmurayeh@gmail.com> - 2016-04-08 04:45 -0700
              Re: Dynamic ( nested) value list ursus <ursus.kirk@gmail.com> - 2016-04-08 16:06 +0200
                Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-04-09 13:20 +1200
              Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-04-09 10:03 +1200
                Re: Dynamic ( nested) value list dempson@actrix.gen.nz (David Empson) - 2016-04-09 11:20 +1200
                Re: Dynamic ( nested) value list Helpful Harry <HelpfulHarry@BusyWorking.com> - 2016-04-09 13:29 +1200

csiph-web