March 12, 200322 yr 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
March 13, 200322 yr 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
March 13, 200322 yr Author thx, verry helpfull how can i change my current project, so I don't lose my relations?
Create an account or sign in to comment