AnsweredAssumed Answered

Anything but a value list

Question asked by Jadelman on Jul 18, 2011
Latest reply on Jul 18, 2011 by Jadelman


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.