I would appreciate help appending certain records, possibly a simple plan.
Scenario: From forma(tableA) must have a button to activate the transfer of a few records from tableB to tableC.
Table B have among all the fields 2 of which, one matches the first option of field_1 in FormA(tableA) and one field that matches the second option of field_1 in FormA(tableA).
to append the records the criteria is based on field_1 & field_2 from FormA(tableA)
Field_1 is contains one of those 2 choices and field_2 is yes/no
I need to append records in tableB to TableC but only those that matches the option of field_1 AND only when field_2 = �NO� in FormaA(tableA).
Also I need, After record appending, modify field_2 in Forma(TableA) to Yes.
In other programs I would create 2 identical procedures to make the appending of records, basing each one on the choice of the value of field_1 in FormA(tableA)
Then create a procedure to select which procedure to run with value of FormA(tableA)
Both procedure will append records in tableC Plus I would have global variables from FormA(tableA) to fill other pertinent data required into TableC. and modify FormA(tableA) field_2 to "Yes".
In ALpha I see in "operations" how to create an operation to append records. Question is how to introduce the values from FormA(tableA) into the process.
Sorry for the lengthy explanation and question
Scenario: From forma(tableA) must have a button to activate the transfer of a few records from tableB to tableC.
Table B have among all the fields 2 of which, one matches the first option of field_1 in FormA(tableA) and one field that matches the second option of field_1 in FormA(tableA).
to append the records the criteria is based on field_1 & field_2 from FormA(tableA)
Field_1 is contains one of those 2 choices and field_2 is yes/no
I need to append records in tableB to TableC but only those that matches the option of field_1 AND only when field_2 = �NO� in FormaA(tableA).
Also I need, After record appending, modify field_2 in Forma(TableA) to Yes.
In other programs I would create 2 identical procedures to make the appending of records, basing each one on the choice of the value of field_1 in FormA(tableA)
Then create a procedure to select which procedure to run with value of FormA(tableA)
Both procedure will append records in tableC Plus I would have global variables from FormA(tableA) to fill other pertinent data required into TableC. and modify FormA(tableA) field_2 to "Yes".
In ALpha I see in "operations" how to create an operation to append records. Question is how to introduce the values from FormA(tableA) into the process.
Sorry for the lengthy explanation and question
Comment