Path: csiph.com!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: Dynamic ( nested) value list
Date: Thu, 03 Mar 2016 18:37:32 +1300
Organization: Aioe.org NNTP Server
Lines: 45
Message-ID: <030320161837322485%HelpfulHarry@BusyWorking.com>
References: <dff63d83-8e99-46ba-9193-ccb07a66aecd@googlegroups.com>
NNTP-Posting-Host: YT6dm5ip/rlawdSjOJF9+g.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:2574

In article <dff63d83-8e99-46ba-9193-ccb07a66aecd@googlegroups.com>,
Mushabab Al-Murayeh <malmurayeh@gmail.com> wrote:
> 
> Hi everyone :)
> 
> I would appreciate the help!
> 
> I want to build a solution for a medical warehouse  and the database will
> contain thousands of records of different materials (consumables)   :
> 
> I start building the solution but I faced a problem with nested value lists:
> I will have 5-6 tables in a file to describe these materials:
> 
> 1. Category (many items)
> 2. Class (to be nested to Categories) e.g. many classes belong to one
> category.
> 3. Type
> 4. Size 
> 5....
> 
> Every table of the above belongs to the table above 
> 
> I want to have a table where once I choose a category only the related
> classes pop up in the class field and the same with once I choose a class the
> related types popup in the type field etc.
> 
> 
> Thank you in advance.
> 
> Please consider attaching a file as a demonstration to your kind explanation
> and support.
> 
> Thank you in advance.
> 
> 
> Mushabab Al-Murayeh, MD

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)