I would like to use a datapage to gather a record from table1, then create a new record in table2, populated with one or more fields from table1.
In this specific example, an administrative user is looking at a new entry provided by a customer. The customer has populated an email field. When the administrator "approves" the entry, the email is added to a separate table (table2), which generates a password (delivered to the customer via email notification).
I don't know how to trigger the creation of the new entry in table2 and use parameters to populate the email field.
Can someone help?
Thanks...