Multiple Drop Down Lists

[Muz Riz]

Hi,

I have 2 Drop down lists on my Layout which are populated from another table. I have created 2 separate value lists for both the drop downs, but they still change together.

As shown in the image below. When i choose a member from the Member name drop down the name also automatically changes in the related to Drop Down List and vice versa. How should i stop that.

 

 

[Steve Martino]

You'll probably have to create a new field for Member Name.  You have both value lists tied to the same field.

[Muz Riz]

Yes that is basically what i want!

I have a Table "tblMembers" with a field "MemberName"

Both the drop downs refer to the membername in the tblMembers table.

I would like to choose a name from the first dropdown and set its relation to another member from the second dropdown.