checking a value in a db before inserting
Using the DataAssist Insert is there a way to check a value in an exsisting recordset before inserting?
Here is what I need to do:
I have two tables that both have date fields in them. Data is already collected for table 1.
What I need to do is when the user enters a date in the second table, it needs to check that the date enters is not later than the date in table 1 before inserting this new record.
So, if the date in table 1 is 2011-01-31 then when a user goes to enter a date in table 2 it has to be before or equal to that date or else the form does not submit.
Is there such a trigger with DataAssist?
Thanks
Brad