In the insert
section of your taf, you should have an Insert Action to add the record to Table
A. Under that, add an IF action to check for <@ARG MFGDirect> =
Yes. Inside the IF, add an Insert Action to add a record to Table
B.
Like
this:
ElseIf _function =
insert
Insert Table A
If MFGDirect = Yes
Insert Table B
-----Original Message-----
From: Cecilia Cos [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 1:26 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Insert to 2 tables based on criteria
Hello All,
I have a Form with one of the fields being MFGDirect which is a yes no field.
When I click submit, I want to check if the MFGDirect field is a Yes or No
If it is No, then I want it to just submit the current form info to table A (this is basically a new record builder which I have already setup)
But
If it is a Yes, in addition to it submitting the current form info to table A, I also want it to submit info to fields in Table B...
Any thoughts on what would be the best way of doing this???
Cecilia C. Cos
Data Analyst
Newsweek | 251 W 57th Street | New York, NY | 10019
212-445-4309
[EMAIL PROTECTED]________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
