I have a list and I what I want is for when a user clicks 'Add new item', they will be presented with two fields.
The first a drop down containing say 3 items.
The second field I want to be populated by data depending on the choice of the first field.
So the logic would be something like 'if user chooses item 1 in column one, present them the following items to choose from in column two'. This way I can nicely restrict how they enter data.
Would I need to use InfoPath for such a thing?