1 Reply Latest reply on Dec 17, 2012 4:38 PM by philmodjunk

    Related value lists



      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.