B
Bill
Non programmer here. Using Access 2007.
I have created a small database to manage a board game we play on a regular
basis. It's a team game consisting of four players, two each side. The pairs
rotate each weekend so its not set.
I have been able to create a table and a field for Team_1 with multiple
entries which can be selected from a combo box drop down list. My problem is
for Team_2. The same drop down list is used and I need a way to prevent the
same player or players from being entered in the field either by graying out
the names already selected or by preventing the record to be saved if a
duplicate name(s) is selected. Hope I explained it properly. I am
struggling to find some validation rule to prevent this but I cant. So it
appears it may require some greater skill which I don't have.
Thanks for any pointers
Bill
I have created a small database to manage a board game we play on a regular
basis. It's a team game consisting of four players, two each side. The pairs
rotate each weekend so its not set.
I have been able to create a table and a field for Team_1 with multiple
entries which can be selected from a combo box drop down list. My problem is
for Team_2. The same drop down list is used and I need a way to prevent the
same player or players from being entered in the field either by graying out
the names already selected or by preventing the record to be saved if a
duplicate name(s) is selected. Hope I explained it properly. I am
struggling to find some validation rule to prevent this but I cant. So it
appears it may require some greater skill which I don't have.
Thanks for any pointers
Bill