Dependant lookup lists?

[msp]

Is it possible to create a dependent lookup list? I.e with two fields the options available in the list for the second field dependant on the value entered in the first field. An example would be “Manufacture” and “Model” of cars. If in the first field “Volkswagen” is picked the options for the second field are “Polo, Golf, Passet etc, whilst if “Ford” was picked “Kar, Fiesta, Puma, Focus ” would be available! This is probably very simple but I cannot seem to find any reference to it in my manual.

 

[Parker]

Is it possible to create a dependent lookup list? I.e with two fields the options available in the list for the second field dependant on the value entered in the first field. An example would be “Manufacture” and “Model” of cars. If in the first field “Volkswagen” is picked the options for the second field are “Polo, Golf, Passet etc, whilst if “Ford” was picked “Kar, Fiesta, Puma, Focus ” would be available! This is probably very simple but I cannot seem to find any reference to it in my manual.

I think what you are looking for is Cascading Combo Boxes? search the forum for such there are loads of examples etc.

 

[dcx693]

You might want to browse the FAQ on the topic: Cascading Comboboxes (it might not be obvious that there is one in the FAQ section since only posts from the last 30 days are shown by default).

 

[msp]

This is nearly what I was looking for, except I was hoping to be able to update a table, rather then just give me a list of options (The table is updated from the list of options). Sorry I was not very specific in my initial question. This has given me some useful pointers. - Thanks for the help.

 

[Mile-O]

This is nearly what I was looking for, except I was hoping to be able to update a table, rather then just give me a list of options (The table is updated from the list of options).

I've also written this in the FAQ Forum.

 

[msp]

Thanks all this now seems to work, (well more or less)