Filter values of fields depending on other fields [message #1550] |
Thu, 14 August 2008 07:56 |
bonzo_bcn
Messages: 152 Registered: June 2008
|
Senior Member |
|
|
I have and add1 transaction for 'team'.
A team has a 'sport' and 'category' fields.
Each sport has it's own categories, therefore I also have a table 'sport_category' with a 'sport' and a 'category' field.
What I want is that in the 'team' transaction, after the user has selected the 'sport', only the categories that belong to that sport should be shown and selectable.
I think this is only possible having the sport and category fields of the team table as popups, right?
Once the 'sport' has been selected, can the value be passed to the popup 'category'?
|
|
|