PDA

View Full Version : Alternative to cascading list


ABC123

malsalcnc
12-18-2014, 06:52 PM
Hi all

I have got my head into a twist over cascading lists on an x_dialog box and need to look at a different way of doing this.

I have a sql database that i am querying.

Apologies for wrong terminology
and bad typing

I need to look in the first table for the first category

I look in the second table, filter out the first category to get the second category

I look in the third table, filter out the second category to get the third category

I look in the forth table, filter out the third category to get the last category

I look in the main table filtered by the forth category and pick the item I require.

and put that into the record I am dealing with.

not looking for specifics but a pointer in the right direction.

regards

Malcolm

Ray in Capetown
12-19-2014, 06:34 AM
In general terms, create a variable for each selection made and use that in the filter of the following selection.