E
EManning
Using A2K. I've got a form for clients that has a subform that is a
cartesian product between client ID and a lookup table (for types of
income). So each client has the exact same number of income type
records.
If the user changes the name of an income type for a client then I want
the change to happen automatically for all clients. I have a
one-to-many relationship set up between the client table and the lookup
table with cascading update set.
In the BeforeUpdate event of the income type, I change the record in
the lookup table to the new value. If I don't do this, I get an error
message that a related record is required in the lookup table when
leaving the row. But I get a write conflict error when trying to leave
the row on the subform.
I'll post code on request. Any help or advice is appreciated.
cartesian product between client ID and a lookup table (for types of
income). So each client has the exact same number of income type
records.
If the user changes the name of an income type for a client then I want
the change to happen automatically for all clients. I have a
one-to-many relationship set up between the client table and the lookup
table with cascading update set.
In the BeforeUpdate event of the income type, I change the record in
the lookup table to the new value. If I don't do this, I get an error
message that a related record is required in the lookup table when
leaving the row. But I get a write conflict error when trying to leave
the row on the subform.
I'll post code on request. Any help or advice is appreciated.