Indexing / Keying Data Masters
The prototype I am working on utilizes 4 unique Data Masters with a cross reference key or keys in each instance. How would you extract/display specific information from Data Mater 1 using its matching key in Data Master 2. For example: The user selects a specific agency extracted from the Agency Data Master and the associated Agency_Key seeks matches for Users in the User Data Master that match the Agency_Key and displays them in a dynamic panel. Agency 1 may have only one user while Agency 2 might have ten.