I think I have a fairly simple problem. I am wanting the user to only be able to choose data from the list box in the table.
Table 1 has a list of departments
Table 2 has a list box connected to table 1.
I want the user to only be able to enter a field from the list box (if the department exists in table 1)
Can I just do this with the valadation Rule? Is this syntax correct?
= [Table 1]![departments]
Thanks for the help