goatmilk
Posts: 10
|
| Posted: 08/26/2008, 3:20 AM |
|
Hi All
I have 1 form which pulls info from 2 tables. There is a field called 'status' that appears in both tables. How can I update both tables when the status is updated via the form?
Cheers
|
 |
 |
maxhugen
Posts: 272
|
| Posted: 08/26/2008, 5:21 AM |
|
There are probably several options in CCS:
- In your 'Record', use the Custom Insert property (and builder).
- Add Custom Code to either the Before Insert or After Insert events for the 'Record'.
Or instead,
- add a Trigger in the db...
Just suggestions from a noobie 
_________________
Max
www.gardenloco.com | www.eipdna.com | www.chrisarminson.com |
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/26/2008, 6:59 AM |
|
As you state 'pull info from 2 tables'I expect them to be JOINed, which forces you to use CustomUpdate.
Let CustomUpdate do the work on the main table, then Event->After Insert you could easily do an update of the secondary table, in code form, as you still have the components available to you.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
