I have cascading prompt on business and region.
Business values: School
College
Preschool
Region values : UK
USA
China
For example if select school in the first prompt and china in the second prompt.
The table should return
Business Region
School China.
But it is returning
School China
College china.
Is this the way the cascading prompt works it selects the last prompt value and displays its related fields.
Is their a way to restrict this and display only
school and china.
itchel (BOB member since 2010-05-26)
(BOB member since 2006-12-08)