How can I automatically make fields active or inactive for data entry ?
I am new to FM and I cannot seem to find an answer to my question in any forum or knowledge base.
The database I set up, is to manage different kinds of business transactions which each have different options for billing.
But I don't want to create multiple tables and multiple layouts to enter the hours, travel time, etc.
What I would like to do, is to have one layout which contains all the data fields reqiured by the 3 options and to have certain fields active (available) for data entry or inactive (unavailable) for data entry, depending on the kind of transaction.
The type of transaction I want to select by a simple checkbox field at the top of the page.
In principle, such settings can be made via the "Inspector" under "Data" - "Behaviour" - "Field Entry", but that would require me to create 3 different layouts.
Does anyone have a solution for this?
I have tried conditional formating and I have looked ats scripts, but couldn't find a solution.