5 Replies Latest reply on Jul 18, 2011 1:08 PM by Jadelman

    Anything but a value list



      Anything but a value list


      I have 3 tables that I am working on, Pits, Materials, and Records.

      Pits has basic information, Name, address, etc but also a portal from Materials.  I track materials and their prices, start date and end date. 

      In Records I have Pit field that is a lookup and pulls the Name of the pit.  The next field would be material that would be able to have a drop down list that shows available materials for the pit that was chosen.

      I have been using value lists but the data is becoming a hassle to update and manage. Is there another way?  I have been toying with portals, but I cannot figure out how to select the Row data that a user chooses.