pissu_kolla
|
| Posted: 11/25/2002, 4:55 PM |
|
hi,
i am really new to all this..and am learning..so any help and being quite detailed is quite helpful..i have done a lot of reading on this forum and am a still bit confused..
basically i have a database with some tables...and i have a table 'reservations' which gets reservations put into it..the fields in this table are username,systemid, statusid
the next table is the table 'system'..which contains systemid,.....and the statusid...
basically i have a form where a user adds a record to the table reservation and i have set statusid=2 (which means taken in the system table) and i want the statusid to update in the table 'system'...
how would i do this...thanks..i am sure this quite simple...and i have a book which explains it to me..but i am not sure how to go about this in codecharge..i have CC 2.0.5 its still the 'trial' copy but i am planning to get the full version later on this week...
thanks a bunch,
-rehan
|
|
|
 |
Tom
|
| Posted: 11/26/2002, 9:52 AM |
|
A basic way to do this is to add code in the properties of the form on the event 'after insert' to perform you a query to your system table.
If you look at the generated code for how CC does an insert/update, you can steal it and modify it to your own
|
|
|
|
|
