Conditional value list within a portal
Would anyone please be able to assist me in setting up a conditonal value list within a portal.
I basically have a SUPPLIERS table and a LOCATIONS table. This is a many to many relationship so I have a join table called SUPPLIERS/LOCATIONS.
On a SUPPLIERS layout I have a portal showing each suppliers different locations. I need a dropdown list first for choosing the LOCATION state, which then using a conditional value list will list the LOCATIONS towns in the next portal field.