Validating field from a quarry.

[ntsabman]

:banghead:Validating field from a quarry.

I have a table with a field that has a value number that I need to validate that that number exist in another table in a field

Table1.field1 Number
Table2.field1 number
So let’s say a have in table2.field1 the list 1 2 3 4 5 8
In table1.field1 I need to validate that the number I enter is present in table2.field1 so 1 would be ok but 6 invalid
and it can't be a from list statement because I need the person to enter a number and get no error or get invalid number
Thanks

 

[ntsabman]

Ok I got it it done and fixed thank to every body that took the time to look at it

 

[Beetle]

That's great if you solved your own problem, but it would be better if you posted the solution so others that might come across this thread in the future might benefit.