ID relation, but dropdown with names

[concrete]

hello,

Now I have 2 databases, one with members and one with payments.

in the payment database I have a dropdown with all the names of the members to make the relation.

but when I change a name (to correct a typo), the relationship is broken.

I know I should link the two by ID, but i can't figure out how to do this with a dropdown with the names of the members instead of the ID.

thx

[Chuck]

You can have two fields appear in the menu. Edit the value list so that the first field is the ID field and the second field is a name field. Then you can select the ID but see which name is attached to the ID while selecting it.

Chuck

[concrete]

thx, verry helpfull

how can i change my current project, so I don't lose my relations?