I am trying to solve a simple question on my fmaker environment: how to check if a record exist and set a checkbox for it?!
I have a layout where some fields are editable like name, let's say that this layout is for invoices. I want to set a checkbox for "new" if the name I am typing does not exist on this layout-db (the name does not appears on previous records) and "old" if it is on my previous records....but I want to do it automatically as I typed the name and a "tab" ou jumped to another field...is it possible?! How?!
thanks a lot!!