Displaying different fields depending on the choice in specified field
I need to find a solution.
I've created a layer which describes different investments of my clients.
I have a field called "TypeOfInvestment" with dropdown menu (bonds, short-term invest, stock, etc.).
Depending on what I choose from dropdown menu (i.e. bonds) I need different set of fields to be displayed on specified area of the layer to describe this particular investment (if my choice is bonds, fields 1,2,3 are displayed on a layer; if my choice is stock, fields 4,5 and 6 are displayed).
I plan to arrange four fields TypeOfInvestment on one layer, because one client may have up to four different investments.
I will be using my database on iPad, so the solution have to work on iOS.
I would be greatful for any advice.
Thanks in advance.