1 DB record accross 4 tabs using AJAX.

[chesty]

Hi All,
I have a flat table with about 60 fields in the table and want to be able to split this data accross 4 AJAX tabs. I can do this fine but how do I allow the user to modify data in TAB 1 for example, and then all data in TAB1 gets submitted for update automatically when the user clicks on TAB 2.

Basically, I want to auto submit the current Tabs data when the user clicks on a new TAB but only be taken to TAB2. I want to do away with a save button on each TAB.

Hope the above makes sense...Not even sure if the above can be done.

Thanks in advance people.

chesty

[Boogle]

Can't you capture the load event on each tab?

If not the best way that i can think of is to separate each tab to it's own dataset. i.e. you only need fields 1-20 for tab 1, well then there's your dsTab1 = fields1-20.

Then whenever tab1 loses focus or gains focus, do an update/select respectivley?

Am i on th right track for you here?

Boog's

[chesty]

Thank you for your reply!
Yes, you are defo on the right track.

'Then whenever tab1 loses focus or gains focus, do an update/select respectivley'
This is where I get lost - Hangon, I think I have got it. When a user clicks on the a tab, I pass a paremeter in the querystring (ie, tab2.php&currenttab=1). Once submited, I have a switch statement,

case(currenttab=1)
'do update
case(currenttab=2)
'do update
end case

` build html for new tab...

Is this what you mean? I think that will work.

Thanks,

Paul

[Boogle]

Exactly that.

Give it a try and let me know if it works

Boog's