6 Replies Latest reply on May 11, 2013 8:00 AM by ChristofBirkenmaier

    How can I automatically make fields active or inactive for data entry ?

    ChristofBirkenmaier

      Title

      How can I automatically make fields active or inactive for data entry ?

      Post

           Hi everyone!

           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.

           Thanks! Christof