Imran
|
| Posted: 09/12/2002, 2:20 PM |
|
I'm not fully familiar yet with all of the functions in CCS, so I've would
like to find out what the best way is for me to update a record in a table
from the custom events of a record form for another table.
I've got a Companies table and a Jobs table. On insert of the Jobs record
form, the Jobs.JobNumber needs to be the last job number used by that
company (from the Companies table) plus 1. I'm using a
Companies.LastJobNumber field.
Basically on insert, I'm creating a new Jobs.JobNumber by basing it on the
Companies.LastJobNumber for that company in this new job, and then also
updating the Companies.LastJobNumber as well. Two table updates at once.
Wondering what the best way to do this would be...
Thanks in advanced...
|
|
|
 |
|
