I have a form with a drop down box so that when you select a category all the complaints within the category are displayed as such
Category = Catering
Short Description
Poor service record 1
Poor service record 2
No variety record 3
No variety record 4
but what i would really like is to then diplay the results by the second field as such'
Category = Catering
Short Description = poor service
record 1
record 2
Short description = No variety
record 3
record 4
any help most appreciated
Category = Catering
Short Description
Poor service record 1
Poor service record 2
No variety record 3
No variety record 4
but what i would really like is to then diplay the results by the second field as such'
Category = Catering
Short Description = poor service
record 1
record 2
Short description = No variety
record 3
record 4
any help most appreciated