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

Groups > comp.databases.filemaker > #2576

Re: Dynamic ( nested) value list

Show all headers | View raw

In article <12c2e85c-70e6-4492-821f-a9bfaa946d6d@googlegroups.com>,
Mushabab Al-Murayeh <malmurayeh@gmail.com> wrote:

> > 
> > If I'm reading that correctly, you've got six separate *Tables* to
> > describe the various materials. You'd be better off with only one
> > "Materials" Table that contains the data for all of those materials. It
> > would certainly make the pop-up menu system easier than trying to drill
> > down through to a sub-sub-sub-sub-sub-sub-Table to get the appropriate
> > value list data.
> > 
> > Helpful Harry  :o)
> 
> Thank you for the reply !
> 
> Would you please expand on your idea ?
> 
> The table you proposed may become very large !

Usually for this type of system you would only need two Tables - one
Table that holds records for all the possible combinations (Stock) and
another Table for the user-entered records (Purchases).

For example, you might have a GroceriesStock Table that has records for:

   Category   Class      Size     Colour
   -------------------------------------
   Fruit      Apple      Large    Red
   Fruit      Apple      Small    Green
   Fruit      Apple      Small    Red
   Fruit      Banana     Medium   Yellow
   Fruit      Banana     Small    Green
   Fruit      Lemon      Small    Yellow
   Veg        Carrot     Small    Orange
   Veg        Lettuce    Medium   Green
   Veg        Lettuce    Large    Green
   Confect.   Choc Bar   Small    Milk
etc.

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)

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