smcnaught
|
| Posted: 12/28/2002, 2:42 PM |
|
I am looking for a way to populate a field in a table from another table when you add a record. In one table there is a command_name and command_line_example. When you add a record to another table I would like to make it so the user can select the command_name for the record and then have the command_line_example inserted into the new record, with the ability to modify it to reflect new changes to the command_line.
I am not exactly sure how to do this without a fair bit of custom coding. I am using PHP and CCS. If anyone could help I would greatly appreciate it.
Thanks,
smcnaught
|
|
|
 |
EMG
|
| Posted: 12/31/2002, 8:44 AM |
|
You could use a custom insert and set the "Data Source Type" property to SQL. Then in the SQL put your insert statement (let CCS build it for you) and your update statement. Seperate the statments with a semicolon.
|
|
|
|
|
