Can one field be dependant on the value selected on another field
Not sure if this is possible, so I thought I would ask.
I have two fields, one country, one postcode.
I have pop up menus for both to make the selection when entering data.
I have two value lists. One for country which is okay, and one for postcodes which is very very long.
Is there any way to make the postcode field dependent on the country field. For example.
If I select UK country then a value list of postcodes in the UK is able to be chosen from in the postcode field, and if the US then only US postcodes etc.
I could create postcode fields and value lists for each country and have them on a tab, but this seems like a dirty workaround.