Hi, all!
I have a table (OrganizationsT) with a primary key field (OrgName).
I have another table (ContactsT) with a field (ContactOrgName) that is pulled from the OrgName field of OrganizationsT.
These fields are linked on a one-to-many basis -- each organization can have more than one contact, but a contact can only be linked to a single organization.
Once a contact has been created, and an organization selected for that contact (ContactOrgName), if I try to edit the organization's name (OrgName) in the OrganizationsT, it won't let me, because it is linked.
I was hoping editing the OrgName would, instead, not only accept changes, but "flow through" to any contacts it is linked to.
Is there any way to achieve this?
With thanks!
--ak