Access Validation Rule Based On Another Table. Pricing Teams Resources Try for free Log In. Search results for validation rule based on another tables field newsgroups and mailing lists 5 replies Parameterize validation rule and text.
A simple solution would be to use the DLookup function to lookup the Goal value from the Goal table and then compare that value to the minimum goal in the Category table. The problem i am facing here is i want to create a validation rule based on particular column which is having several dates in those dates i need to pick only the latest date from that field. Date date cannot be in the past.
Draw a join line between the FK former lookup field in one table to the PK in the other.
Access performs this validation for data entered in a Table window in Datasheet view in an updateable query or in a form. Validation Rule for field using table property. Draw a join line between the FK former lookup field in one table to the PK in the other. Ill cover the following topics in the code samples below.
