I have the following three alphanumeric columns in my table:
Organization_ID (Unique) Parent_ID Child_ID
The Child_ID is comma delimited, so a parent can have multiple children.
I'm trying to make it so that when a User updates the Organization_ID it will update in the Parent_ID and Child_ID. I'm fine with these being two separate Update commands. Also can you please tell me how can I report orphaned units as well?
Thanks for the reply. I just realized that the Child update portion won't work because there are multiple values.
Basically when a User update Organization_ID I want to run an Update Command that Updates the Parent_ID value of all of its children since, in this case, the Organization_ID and Parent_ID should remain the same.