Path: csiph.com!aioe.org!.POSTED!not-for-mail From: Helpful Harry Newsgroups: comp.databases.filemaker Subject: Re: Dynamic ( nested) value list Date: Sat, 05 Mar 2016 10:03:16 +1300 Organization: Aioe.org NNTP Server Lines: 51 Message-ID: <050320161003162488%HelpfulHarry@BusyWorking.com> References: <030320161837322485%HelpfulHarry@BusyWorking.com> <12c2e85c-70e6-4492-821f-a9bfaa946d6d@googlegroups.com> <040320161822264078%HelpfulHarry@BusyWorking.com> <147fae8c-b051-4c51-861a-d29a70b077f9@googlegroups.com> NNTP-Posting-Host: wzLrQeXID5B+voFEwQLzPA.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], Mushabab Al-Murayeh 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)