AnsweredAssumed Answered

Related value lists

Question asked by obidon on Dec 17, 2012
Latest reply on Dec 17, 2012 by philmodjunk


Related value lists



     I have a company table with Company_UUID and Company_Name Fields

     I have a branch table with Branch_UUID, Company_ID and Branch_Name fields

     I have a third table called tests.  Each test record will belong to a company by selecting a UUID via a popup menu.  I want to then select a branch by UUID using a filtered/related value list.

     I have this working in other areas by simply creating a table with  Company_Name (Simple Value List) and Branch Name (manual Entry).  How do I streamline this?

     I believe that I need a list which combines Company_Name & Branch_Name to facilitate this.