Validation Rule Question

[KPR1977]

I want to set a validation rule that will not allow me to input data in field1 in TableA that is not found in TableB under field2. Basically, Table B under field 2 has the following row entries: Apple, Pear, Lemon, Orange. When I input data in field 1 for Table A I want it to give me an error message if try and input Watermelon (since Watermelon doesn't exist anywhere in Table2.) If anyone could help me out with this, it would be much appreciated.

Here's what I tried as a validation rule, but of course it didn't work.
Validation Rule: in([TableB].[Field2])

[MMcCarthy]

I want to set a validation rule that will not allow me to input data in field1 in TableA that is not found in TableB under field2. Basically, Table B under field 2 has the following row entries: Apple, Pear, Lemon, Orange. When I input data in field 1 for Table A I want it to give me an error message if try and input Watermelon (since Watermelon doesn't exist anywhere in Table2.) If anyone could help me out with this, it would be much appreciated.

Here's what I tried as a validation rule, but of course it didn't work.
Validation Rule: in([TableB].[Field2])

Forget using a validation rule. Just change the field in TableA to a Lookup list based on the entries found in TableB and limit to list.

[KPR1977]

Forget using a validation rule. Just change the field in TableA to a Lookup list based on the entries found in TableB and limit to list.

That was easy. Thanks!!! =)

[MMcCarthy]

That was easy. Thanks!!! =)

No problem.