on UBER-filtering and other things bound to give me an ulcer

[BMan111]

Ok, on my project list db that I have been working on I have been told that I need a list of all projects affiliated with the current project.
The table looks as follows:

tblAffiliated_Projects
Primary_Project_Number -> text field -> Primary key
First_Affiliated_Project -> text field
Second_Affiliated_Project -> text field
Third_Affiliated_Project -> text field

None of the three affiliated fields can be the same, and none of them can match the primary number. This part I can more than handle with out a problem (mostly thanks to KnooKie and his high amount of paitenct for my ignorance).

What I need is to have 3 combo boxes, each with a list of the project numbers & names appear. then when you select one number as being affiliated, it removes that number from the other two boxes.

Anyone with an idea how to pull off this filter/sort?

Brandon
-=sometimes nothing can be a real cool hand=-

[KnooKie]

You can do this in exactly the same way you did that filter in the other post i helped you with except you want to exclude (<>) a value rather than filter to it.

Does that help ?

[BMan111]

actually, yes it does. That makes a lot of sense. Again, i figured it was somethign simple like that, but as I hadnt built the form yet it seemed like it would be much harder when I was planning it in my head.

Brandon
-=sometimes nothing can be a real cool hand=-