make "if" function able to compare values from two tables
I have a table of plants, and a table of when & where each plant is planted (one to many relationship).
I need to check which plants I have in stock that I haven't planted yet
Could you please send the database backup file ( .pdmd) to email@example.com so we can check it on our side to see whether it is possible to achieve the requested behavior? T
...the table "when planted" uses a table relationship field to select the plant name from the "plant info" table