I've got a question about references, is it possible to specify criteria for the Reference.  For example, Table 1 has Field1 That References Field1 in Table2, However I only want Field 1 in Table 1 to reference the Records in Table2 that have the Valid Field set to TRUE.  In other words, I don't want the user to be able to enter invalid records from table 2 into field 1 in table 1.  Is there a different way of accomplishing the same thing?
 

Reply via email to