i have a table with every office employee on it and in it i have a field called codes
in my sales form i have a dropdown box that selects the people who i have assigned a " 1" to
i also have a dropdown box for purchasing of which i have assigned a " 2" to
the same as above for finance but i have assigned a "3" to
all works ok
but the problem i have is. lets say 1 want to use the same person to do any other the 2 or 3 things how could i do that in my table
or would i have to 3 tables for each function with thier names in each on and ref that table
thanks
steve
in my sales form i have a dropdown box that selects the people who i have assigned a " 1" to
i also have a dropdown box for purchasing of which i have assigned a " 2" to
the same as above for finance but i have assigned a "3" to
all works ok
but the problem i have is. lets say 1 want to use the same person to do any other the 2 or 3 things how could i do that in my table
or would i have to 3 tables for each function with thier names in each on and ref that table
thanks
steve