do i take the lack of replies to mean its a dumb question or noone knows how to do it?  it seems like a basic feature that many have been looking for answer too.

I appreciate any help. I was more wondering if i was chasing a rainbow or if i had a realistic goal.  i have only been coding for a few days in this tool so didnt want to be bogged down with something i could never get working

I have a grid with players in it.  the players have a record for every week they play.  the week drop down is created by a separate process.  so after week one the drop down has a 1 in it.  after week 2 the drop down has 1,2 and so on.  the stats dont get updated every week so sometimes i will go in later say week 3 and the dropdown says 1,2,3.  So i choose week 1 and add a record.  Now I want to add a new row and the drop down should only allow 2,3 to be selected.    this changes for every player.   The grid knows which player is being modified so the drop down would need to pass that to the ajax that builds the select.  in the sql call it looks to see if a week already has a record and knows not to send it back.

 

so in essence the select is not built on something that happens to a field in a row but by what ID was used to build the grid. 

I think i understand it could be done if the select was built every time a add event fired, just trying to find an example of how to do that..

thanks