1 Reply Latest reply on Dec 10, 2010 8:34 AM by philmodjunk

    create a dropdown picklist with data from 2 differnt tables

    ClydeMills

      Title

      create a dropdown picklist with data from 2 differnt tables

      Post

      I have 2 tables "vendors" and "libraries"  I need the dropdown picklist for a field called vendor in a 3rd table to be populated with the vendor and library names from the vendor and Libinfo tables.  Is there anyway to create a picklist from 2 different tables?  I know you can create a picklist from 2 different fields in the same table but not sure if you can use 2 different tables.

        • 1. Re: create a dropdown picklist with data from 2 differnt tables
          philmodjunk

          It's not impossible, but requires valid relationships to be in place.

          Do you want a value list where Library is in column1 and Vendor is in column2 or Vice Versa?

          What relationships have you defined linking Vendors and Libraries?

          The fact that you have both "Vendors" and "Libraries" suggests you may want to implement a conditional value list where you either specify a vendor and see the list of only the Libraries for that Vendor or specify a Library and see a list of only the Vendors for that Library.