Insert A Record Into Another Table

Greg,
you can do it using events.

Proceed to the Events tab, select Before record updated event and add your code in it.

Here is a sample code:

Function BeforeAdd(dict)

strUpdate = "update Logons set GroupID='new value' where OrgID=" & dict("FieldName")

dbConnection.Execute strUpdate
BeforeAdd = True
End Function

where FieldName is your actual table name in the main table.

I couldn't seem to get that to work..it didn't change the field
I have 2 tables
one with contact info and organizational info named YIRDB

YIRDB contains all of the info that is being edited / added to using asprunner
and the other table is called "Logons"
Logons contain the organization ID, Password & GroupID
I want to change the Group ID in Logons from Teacher to Teachers2
thanks for your patience

Greg,

you can do it using events.

Proceed to the Events tab, select Before record updated event and add your code in it.

Here is a sample code:
where FieldName is your actual table name in the main table.

Greg,
sorry for my fault. Here is the correct code:

Function BeforeEdit(dict, where)

strUpdate = "update Logons set GroupID='new value' where OrgID=" & dict("FieldName")

dbConnection.Execute strUpdate
BeforeEdit = True
End Function