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.