update info in related file

[concrete]

I have 2 databases

one with housting accounts and one with dns names.

when I input a new dns name I have a drop down list to select an account by it's name.

what I want now is that when I change the account name in the account database, that the account name in the dns database is updated.

[Geeksharka]

In order for that to happen, The DNS table records will need to know which Account file they're related to, and either relookup the AccountName field (based on the new name), or better yet, simply show the AccountName directly from the Account table via a relationship.

However, IF you set up the relationship to be based on the AccountName field, then by virtue of changing the Account's name -- you just broke the relationship, meaning there's no way for the system to know what it's meant to be relating to, or updaitng, or looking up, or... you get the picture.

Instead of using names as the relationship key, that might change down the line, use auto-enter, serial number, unique ID fields instead.

HTH