RE: Witango-Talk: Insert to 2 tables based on criteria

2004-07-09 Thread Wilcox, Jamileh \(HSC\)
Title: Message 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     I

Re: Witango-Talk: Insert to 2 tables based on criteria

2004-07-09 Thread Rick Sanders
04 2:45 PM Subject: Re: Witango-Talk: Insert to 2 tables based on criteria Put an "If/Else" in the Insert action; if yes, do this, if no, do something else.Image:Cecilia Cos wrote: Hello All, I have a Form with one of the fields being MFGDirect which is a yes no field.

Re: Witango-Talk: Insert to 2 tables based on criteria

2004-07-09 Thread Charles Brown
Put an "If/Else" in the Insert action; if yes, do this, if no, do something else. Image: Cecilia Cos wrote: 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

RE: Witango-Talk: Insert to 2 tables based on criteria

2004-07-09 Thread Ben Johansen
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 a

Re: Witango-Talk: Insert to 2 tables based on criteria

2004-07-09 Thread Rick Sanders
Hi Cecilia,   What you need to do is set up an IF and ELSE action for where the form is posting to:   <@IF EXPR="<@ARG MFGDirect>=Yes"> Table A <@ELSE> TABLE A & B   Let me know if you need more assistance, or an example WiTango file.   Rick Sanders - Original Message - F