1 Reply Latest reply on Nov 23, 2009 8:18 AM by philmodjunk

    Conditional Value Lists



      Conditional Value Lists


      I am creating a database that will be used for billing. I have an Accounts Table and Billing Table. The Accounts table keeps the contact information. The Billing table is for generating invoices based on what projects were done for the individual accounts. For each Account there is a department and budget number. I am able to create a conditional value list on the billing layout that allows the user to select the main account and then see only the departments for that account. What I would now like to do is based on the user input of main account & department have the budget number for that department auto-populate. I've tried to create multiple level CVLs but that hasn't worked so far.




      One main account is Academic Services. For this account there are the following departments (w/ corresponding budget numbers): Admin (7100), Science (1100), Professional Development (7393).


      How can I make it that if someone selects Academic Services and then Admin the budget number will automatically display 7100?


      I'm VERY new to FM & I have no training. I'm learning by "feel".


      Thank you for any help you can offer.

        • 1. Re: Conditional Value Lists

          I don't see a need for an additional conditional value list. The simplest way to see the budget number in a layout based on your Billing table is simply use the field tool while in layout mode to add the budget number field to your layout. This assumes you have the following relationship linking your two tables:


          Accounts:: Department = Billing:: Department


          Depending on what other relationships exist in your graph, you may have to create a new table occurrence with a different name to support this.