Jun 24, 2024 10:26 AM
I have two tables Tenants and Property so i am creating a new record in a 3rd table called interaction where condition is The tenant's move-in date should not be more than one month later than the property's availability date.How to do this ?
Jun 24, 2024 07:23 PM
You could try using the trigger "When record enters view" and create a view the move-in date meets your conditions