Skip to main content

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 ?

You could try using the trigger "When record enters view" and create a view the move-in date meets your conditions


Reply