Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2578

Re: Dynamic ( nested) value list

Show key headers only | View raw

In article <147fae8c-b051-4c51-861a-d29a70b077f9@googlegroups.com>,
Mushabab Al-Murayeh <malmurayeh@gmail.com> wrote:
> > 
> > You would then have another Table which is used to create
> > ShoppingListPurchases. In this Table, you would have a Category Field
> > that shows all the possible Categories (Fruit, Veg, Confect., etc.). If
> > the user chooses "Fruit" from the Category Field, the Class Field's
> > pop-up menu will show just Apple, Banana, and Lemon. If the user then
> > chooses "Apple" from this pop-up menu, then the Size Field's pop-up
> > menu would show only Large and Small. If the user then chooses "Small"
> > from that pop-up menu, then the Color Field's pop-up menu will show
> > Green and Red.
> > 
> > If you have separate tables for the four Fields / columns above, then
> > it becomes very messy (as well as taking up a lot more storage space
> > and unnecessarily duplicated data) to try and create those Value Lists
> > for the pop-up menus.
> > 
> > Helpful Harry  :o)
> 
> Thank you . Let say I will have 
> Category (15 )  Class  (for every category 3-6 )   Size  ( for every class
> 5-10 )    Colour ( for every size 3-7 )
> 
> Then how many combination I will have to construct this single table . Beside
> If I want to add more categories in the future then I have to update all
> classes, sizes and color !!!!
> 
> This why I want to have a table for each ( Category   Class      Size    
> Color ) to update them separately .
> 
> Thank you . Patiently waiting for any response 

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)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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