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.