Conditional Dropdown List

[Greg58]

Hi.  I have 2 dropdown lists of which one is dependant on the other.  So if I select MEAT in the first fields only MEAT related selections are available in the second.  I can add items that are not in the list OK, but they are not retained for future selection.  Can anyone assist please??

[comment]

If your value list is defined to use values from the Category field in the Values table, then adding a record to the Data table is not going to affect the available values. Either use values from the Data table (which means your value list will be initially empty and grow as the user adds records), or have a scripted process to detect user adding an item not on the list and create a corresponding record in the Values table.