This has probably been asnwered 000's of times but I cannot find any reference to this that I understand so here goes, being new to PHP/Javascript but with a db developer background.
My page consists of a table(array) so that it simulates a spreadsheet.
Each row has several select option lists which are populated from SQL queries, can do this quite happily.
My problem is that when I select a value for option list 1 on row 1 I want the other option lists (2,3, and 4) to update (or populate if that is easier) relative to the value in option 1. However I do not not want the other option lists (2,3, and 4) to be updated on the other rows, these will be relative to option 1 on that row.
Once I have finished I cycle through the table/array and save each row to the db.
The reason for wanting this is to alow only valid data to be entered i.e. if option 1 is model of car and option 2 is colour then not every car is available in every colour.
Thanks In Advance
Trev
