Combo Boxes (1 Viewer)

[mattP]

Ok so another query from me today.

On my database I have a number of different teams, on some of the combo boxes not all the entries are relevant to all the teams but they may also share some of the same entries in the combo.

Can I have the combo filter it's drop down list dependant on the team that the user is under, understanding that on some entries 3 or 4 teams will want to view this.

I was thinking along the lines of for the relevant table, have fields for each team and then a yes no check box ?

So for entry line 1, team 1, 2 & 4 have yes but 3 &5 are no, so they do not see it in there drop down ?

Many thanks

MattP

 

[neileg]

This is known as cascading combos. Do a search on this in these forums. Plenty of help.

 

[mattP]

Neileg,

I've used Cascading combos already on another combo however on this particular issue I may have a table entry that is visible to 4 out of 5 teams and another that is only available to one out of the 5 teams.

I could not find anything in the forum relevant to this particular way I want to do this ?

Regards

MattP