I am trying to make myself a simple-ish demo to test out auto-complete/display on a site using a few rules.

Basically I'll have a form with 5 or 6 text inputs, each one an Auto-Complete.

I'll have 5 or 6 corresponding tables, each 10-20 records on length. The tables will be in something of a Matrix as each will have correspondence to the other e.g. Table 1 / Record 1 will have a value for each of the other Tables e.g.
Table 1/ Record 1
Name
Table2Value=X
Table3Value=Y
etc

so the tables will link.

The tables themselves will also be hierarchical e.g
MainValue
SubValue
SubSubValue


I'll want to be able to place an AC, give it a display title and then have define which table to access for the AC

Additionally I'll want to be able to do a limiter on each AC based on the values in a prior AC so:

Input 1: AC from CarMake

Input 2: AC from Table CarModel Where CarModel_Make = Input1_CarMake

Ideally in fact each Auto-Complete will call all values from the defined table but sort using the above 'limiter'

User can enter more then one value. Ideally as they select it adds to the left as a checkbox

[Enter Value]

[Gre ]
Grey
Green

User Picks Green

[ ] [x] Green

and can add another color or remove green with the checkbox

Once user adds all values and hits 'Submit' that makes a new Inventory Record

***

Step 2 will be modifying those selections each of which come from the nested tables and can easily modify either way;

Table 1: MainValue>
Table 2: <SubValue>


Right arrow shows list of subvalues to select

<SubValueV
SubSubValue1
SubSubValue2

User selects SubSubValue 2

Table 1: MainValue>
Table 2: <SubSubValue2>

or from Table 1:

Main ValueV
SubValue1
SubValue2

User selects SubValue2


Table 1: <SubValue>
Table 2: <SubSubValue2>

or can go up a level using the left arrow (only one option of course)

Table2: SubValue <SubSubValue2>

Table 1: <SubValue>
Table 2: <SubValue>

and again

Table2: Value <SubValue>

Table 1: <SubValue>
Table 1: Value>

and of course on the top (or bottom) of the nest no arrows show.

***

Finally, there will be another table, let's call it Inventory which will have a # of Records with a Name and then a value from each of the tables e.g. (making up all these values as example)

Widget A
Table 1 (Color): Dark Blue
Table2 (City): New York

Widget B
Table 1 (Color): Blue
Table 2 (City): Istanbul

Widget C
Table 1 (Color): Red
Table 2 (City): Chicago

And these now display using the values from the selection shown before

Table 1: <Dark Blue> Widget A
Table 2: <Chicago> Widget C

and if the user now modifies the Table Seleciton

Table 1: Blue < Dark Blue>

the inventory updates

Table 1: Blue > Widget A
Widget B

Table 2: United States < Chicago>

Table 2: United States> Widget A
Widget C

__________________

Pretty straightforward, I should be able to name the tables/fields and define which AC calls what and what the "Where" is.

Doesn't have to be pretty, if you can do this with existing Ajax ACs and modify for me a bit that is fine too, just experimenting.


____

Ammendment

On the first part of the task Auto-Complete I will have ONE input that requires querying two tables in order let's call them Color and Type

[Enter Type]

So if user types 'Seda' they'll get 'Sedan'

In the next input I was going to put let's call it color:

[Enter Desired Colors]

and user can pick a # of colors

In this case though for type I'll allow user to pick color and type

[Blue Se ]

= Blue Sedan

[Black Lux ]

= Black Luxury Car

So the additional table becomes a prefix table to the value AND also assigns a value for the Color Table

When user does get to Color table if they've chosen one in the Type table e.g. Black Sedan

then that is already one selected value

[Enter Desired Colors] [x] Black

and user can enter more as per original description

______

Simple Text Search on Inventory (the ones I add with boxes and the ones I added as records manually)

Auto-Complete on All Tables

Also joins the two tables I previously mentioned so if user chose

[Black Luxury] in the AC with the two table query

but also added other colors in the Color AC (Grey, Green)

then the search would find Black Luxury, Grey Luxury, Green Luxury.

___